DSXchange

Rupesh,

Just see if you are using any datastage function in the Lookup Stage where you give the look up condition.

It might be possible that, to perform that function it might be fetching the data into the CURSOR.

Yogesh

Mike I agree, I had posted regarding this doubt before also. here is some text from same. According to Ray Sir, the solution is working fine of checking if the key is already existing in the table but i am just trying to figure out the scenerio where an insert by other process into the same table mi...

Mike, After lots of trying the work around on which we have come is like this We are developing an external routine which excepts these four input fields that needs to be inserted into the table. and will return a flag depending upon the SQLCODE whether the insert was successful or not. We can than ...

Mike, My code is not getting ABEND, the return code of the program execution is 4 There are 12 records in my input file Report file reads as follows Records read from DDNAME DD00002 001 000 records have been inserted into table CLIENT_REF Records written to DDNAME DD00003 001 Records written to DDNA...

Hello Everyone, I have a developed a job in DS MVS, in which i am reading records from an input file and inserting them into a Table. But my code stops working if the database (DB2 on mainframe) rejects the row due to Duplicate constraint. I dont want to do a look up (on the value which i am inserti...

Hello Kumar_s, I couldn't get where do you set the arry size property in mainframe job. More over i have set the row per commit as 1. How does arry size matter while insertion fails into the table. Would definatly like to know about this if this can be of any help to me. my job is something like thi...

Hello All, I am developing a job in which i have 3 output links. The first link writes into a Table (Client) The other two links are writing into files depending upon the success or the failure of the write into the above table. for the first file the link constrain is L_Create_Client.REJECTEDCODE =...

I am trying to change the way that nulls will be indicated in my LR file.

Thanks
Yogesh

Hello every one, I am facing a problem with regard to Null indicator. In the job properties Tab, i am defining the Nullindicator value as '?' (character) and the Non Null ValueIndicator Value as 'N' But still when I generate the code the program contains the Null Indicator as 1 and the nonNull value...

Hello ray, I had made a simple test job where i am reading a column from one file and writing the same to another output file. I have just three stages two Fixedwidth FlatFile and one transformer. We are able to compile the code on the mainframe but when we run we get S0C1 error. Also i wanted one m...

Hello All,

I am facing a problem while running the jobs on MF.
We have FTPed the required files to the mainframe during the installation. But while running the jobs we get SOC1 error.

Can anyone help me in this regards.

Thanks in Advance

Yogesh

Hello All, I am new to Datastage MVS and mainframes. I wanted to know what role does the number of MIPS play in executing the programs generated by MVS. I can understand that more the number of MIPS more will be the speed of execution, but what i would like to know here is , is there any minimum num...

Thank you all for this valuable information.

Regards
Yogesh

Thanks for the information.
If we dont worry about the performance,
is there any constraint on the record length that a sequential data file shoud have in datastage?
And if so, Is it different if the data is in ASCII or EBCDIC??

Hello all, I did a search on maximum file size and also got some useful information. A small doubt, Does the record length in a sequential file also matters in performance? and does the record length matters if the data is in ASCII or EBCDIC ?? Are their any constraints on the record length to be us...