DSXchange

I totally agree with you Mike. I have been working on DS MVS for last 3 years and I would not recommend anyone to change the generated code (unless you want to pass a parameter from run JCL). This was one exceptional case which required this sort of altering. (I would not mind as far as it does what...

Mike I think I did not explain it correctly. Following is the problem and its solution. Problem: .................... Customer table ..............................| ..............................| ..............................V Raw data -----> lookup -----> Files (Multiple) Source is raw data with ...

Mike Well, there are limitations of the tool as there are less options on transformation. This is what I am doing to resolve the issue. Hopefully it should work. At the end of the day, the datastage job is a cobol program. For it to run requires jcl and compile is compile jcl. I am developing a data...

Thanks Mike.

Its the option 1.

The need is to create different files for different customers, so yes, if 5 customers match, 5 files should be created.

Regards
Rupesh

Hi How can I create target files on the fly in datastage MVS job? Example: Source - Raw data (key Customer ID) lookup - Customer table (key Customer ID) target - dynamic (dynamically create fixed width files depending on the number of customers matched in lookup) Your help in this case will apprecia...

Hi Commit frequency in Job properties is related to the number of rows it processes. Meaning, if the values is 100, it will commit after 100th record is loaded successfully on the target table. This should be true for one output link to one target. What happens if the input is one and output links a...

Hi This query is related to DataStage mainframe job. The job reads from a DB2 table and performs inserts in different tables in one job. The commit frequency in Job Properties is set to 0, meaning that it should commit after all the rows are processed else rollback. But recently I've observed that i...

Yes it worked.
I was using Trim() function in my look up stage.
I removed it and no more CURSOR in the cobol code. :D

Thanks a lot for your help.
Rupesh[/img]

Yes The radio button is singleton for both the stages.

But i am really surprised why the datastage generates the code differently for two similar kind of look ups.

Hi All I am using two lookup stages and their respective Relational stages from which they do the look up. But in the cobol code generated , one of the sql is generated using cursor. and for the other look up stage its just a direct row fetch. I am not able to find out how can i stop the cursor gene...

Mike, one more problem which I am facing is Is there a way in MVS where I can handle a rejected row of Database Insertion due to Primary key constraint. As of now everytime I insert a row into a DB table I am doing a look up before that stage, to make sure if the row is existing in the table already...

Thanks Mike. Actually I didnt understand the part in the following quote. The best that you can hope for is that the code optimizer will push a transformer constraint back into the SQL WHERE clause. Do you mean to say that one of the constraint in WHERE clause can be put into transformer Constraint?...

Thanks a million Mike. That really helped. So far I was following the same approach, but did not think of spliting it first into a file and than looking up. DB2 table with query | | V input----->Transformer---->lookup----->Transformer------>DB2 Loadready File. Definately there would be a performance...

Mike, As I mentioned early, "billion of rows coming from Input and 1000s of rows in lookup table" this should expalin it all. But for your clarification Is it the relational table, FORM_TAB_V, the input source with the billion rows? Or is that the input source with thousands of rows? Answe...

Yes, we are talking about billion of rows coming from Input and 1000s of rows in lookup table.

Other two host variables are set to defaults like PB90H-FRM-ST-CD = 'UK' and PB90H-FORM-EDITION-DT = CURRENT_DATE

Hope that really helps.

Regards,
Rupesh