MVSFORUMS.com

I just removed the semicolumns for DATAID field while issuing the LMINIT command. It worked now. What I am wondering is for first execution why it didn't give me any error.

I had like this

MY ...

Hello MVS Forum members,

I am having an issue while executing a Rexx which has LMOPEN command. What my Rexx doing is, it will read an input file which will have PDS names.

USERID.TSO.PDS1
USER ...

I just tested, it failed with -803 error and remaining records are not loaded. I thought it would discard the duplicates and continue with rest of the inserts like LOAD utility. But didn't workout.

Can I use Mass INSERT statement in my application program like the one given here.

INSERT INTO TABLE A
SELECT * FROM TABLE B;

If I can use above statement in my program, what happe ...

Kolusu,

I agree 100% with you about usage of host variables. My question is specific to mass insert into table A by selecting records from table B. While doing that if I don't have one to one colu ...

Thanks Gotluru.

Hi All,

Can I use host variables in SQL INSERT statement when I am selecting records from other table. Here is the code please advice me.

TABLE-A has FOLLOWING COLUMNS

COLUMN1-A, COLUMN2-A, ...

At last we found the answer after doing lot of research on this.
In order to see the values in output parameters we need to close or destroy the recordset before accessing the output parameters.
...

Not a happy news, this is forcing me to write a cobol pgm to format the data.

Thanks again Kolusu.

- Pradeep

Hi Kolusu,

My data fields in the input file always won't start at the same position.
We are getting this data file from C/S environment. In the following example NAME field wouldn't always start ...

Hi Everyone,

Let me re-phrase my question.

Is there any opiton available on LOAD utility through which I can tell the utility that each filed is separated by a comma in input file (INDDN).

...

Hi,

Can I use the file which has the fields (data) with comma seperated as input instead of fixed length data file for loading by using LOAD utility.

Thanks.
Pradeep

Yes we have referential integrity constraints on our tables. About the loading process, thanks for your valuable inputs.

Thanks everyone for all your thoughts and inputs. Load utility manual has g ...

Hi Ajey,

You mean to say when we switch off the constraints, it is programmer's responsibility to check the data validity (Primary key, foriegn key relations ships etc....). Is that a true statemen ...

Hi kolusu,

DB2 LOAD utility itself taking 2 hrs. time for 22 million records really scared me, because we are estimating approximately around 200 million records to load. So there is no way we use ...