ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

Search Result

Collapse
5 results in 0.0019 seconds.
Keywords
Members
Tags
insert x
  •  

  • Slightly Complicated Statement works one place not another

    So, I have the following SQL statement.
    PHP Code:
     EXEC SQL
         INSERT INTO ENTPART 
    (IRS#,ITEM#,OKAYTOUSE,HTS#1,HTS#2,HTS#3,
         
    DESC,UNT$,WGTLN,PCLS,PRDCD,COMM1,COMM2,COMM3,COMM4,COMM5,
         
    COMM6SELECT DISTINCT (SELECT IRS#CS FROM CUSTHEAD
         
    where CUS#CS = $S_CUSTF 
    ...
    See more | Go to post

  • inigo.redin
    started a topic Trying to run big SQL script from IFS, using RUNSQLSTM
    in SQL

    Trying to run big SQL script from IFS, using RUNSQLSTM

    Hi!


    First time publishing here. Thanks for your ideas!

    I'm trying to run a big SQL script.
    It is composed by INSERT sentences. About 500.000.
    Just to try one way to migrate one file into iSeries, from another DB.

    It's ok, if the file...
    See more | Go to post

  • techas400
    started a topic SQL insert into 2 libraries with 1 query
    in SQL

    SQL insert into 2 libraries with 1 query

    I have the following query in SQLRPGLE for DB2:

    Code:
      INSERT INTO ITEMS2 (PROGRAM, VLDFILE, VLDFLD, 
        SELFILE, SELFLD) VALUES(:SCAPP   , 'CSTMR', 'CYC',
        'BYC', 'BYCC');
    I would like this query to be run in 2 libraries as in FIRST/ITEMS2 and...
    See more | Go to post

  • GerardMainardi
    started a topic Insert data from SQL Server 2008 R2 to AS400

    Insert data from SQL Server 2008 R2 to AS400

    I'm not sure if this belonged in the SQL forum, or Freshers!...

    I'm trying to insert rows from SQL Server into the AS400. While I can pull data down without issue, I'm not even 100% sure that this is possible, so I wanted to ask the experts. I've tried it two different ways, and I...
    See more | Go to post

  • Adein
    started a topic SQL Insert Failing when trying to update to null
    in SQL

    SQL Insert Failing when trying to update to null

    I have a simple, whole table update that is failing, and throwing all kinds of messages into the Job Log, but not stopping the program or further execution.

    SQLSTATE:23502 SQLCOD:-407

    Message is: The insert or update value is null, but the column cannot contain null values....
    See more | Go to post

Our Sponsors

Collapse
Working...
X