DSXchange

Hi all, I have a simple load job which loads a dataset into the target DB2 table using DB2 Enterprise Stage. Dataset (Country) ---------------> DB2 Enterprise Stage (CTY) I'm running the job with the below config file, which consists of 4 ETL Server nodes and 4 remote DB2 nodes: { node "node1&q...

case no for the patch: 128834.

Hi all, This is my first time working with db2 as a target database. With respect to datastage, are there any precautionary measures that need to be taken when loading into db2? For example, is there anything to be taken care of or set if we are loading about 40-50 million rows/table into db2 on a d...

Got a patch from IBM to call it in a stage variable. And now it works!!!

rleishman wrote:Are you trying to use NextSurrogateKey() in a Stage Variable?

If so, I don't believe that you can. You can only use it in an output link column derivation.

You can get a patch from IBM to call it in a stage variable.

Hello all! How can I write a new stage? To avoid additional questions: yes, I need a new stage, not function. If you are trying to figure out on how to get started on building new stages, then start by right clicking on the "Stage Types" category and go to "New" ---> "Other...

santosh wrote:Not an excellent way of doing it but would like to suggest an option below.

Santosh,

Can you explain why a "Build-Op" is not an excellent way of doing it compared to your round about method?

Thanks,
Whale.

That technique would work, but it's wasteful, and would require a priori knowledge of the maximum number of rows that might need to be generated from any one range (in your case 100 was sufficient - or was it ?!! How would you know (in all cases)?). Exactly! ATBolton's solution wouldn't work as Ray...

Dont you have RangeLookup in Version 8?? And more over, how would following record has only 4 entry? MIN_ZIP_CODE MAX_ZIP_CODE 75101 75114 Just an typo?? Oops!! Sorry, Folks. Had a long day. Yes. It should have been 04 and not 14. I don't think range lookup will be of help. I have corrected the pre...

Hi all, I have a input file with two columns (MIN_ZIP_CODE and MAX_ZIP_CODE). For example: MIN_ZIP_CODE MAX_ZIP_CODE 75101 75104 89430 89435 00010 00015 I need to generate the output as follows: MIN_ZIP_CODE MAX_ZIP_CODE ZIP_CODE 75101 75104 75101 75101 75104 75102 75101 75104 75103 75101 75104 7510...

rleishman wrote:I believe you can only set NextSurrogateKey() to output link columns - kind of limits it's usefulness.

That is awful. I would think it is a bug rather than it being a limit.

Whale.

Thank you, Ray. I learnt that IBM does not support that kinda installation.

Cheers,
Whale.

Hi all,

Does anyone know whether it is possible to install the Information Server 8.0.1 - Client on a Citrix Server and have it accessed by 10 users.

If so, what would be the memory requirements like?

Any help is greatly appreciated,

Best Regards,
Whale.

Hi all, I'm trying to assign the NextSurrogateKey() function to a stage variable. The job compiles fine but aborts with SIGSEGV error message. Has anyone encountered this before in IS 8.0.1? Or in 7.5.2? The exact error message is as below: X2,0: Operator terminated abnormally: received signal SIGSE...

Arnd and Ray, Thanks a bunch for all the help. Although I have the DB2 Enterprise Stage. I did not need it. Because I failed to do a simple test in the first place. I curse myself for not doing it. ( :evil: at myself). When you mentioned key values, I did further inspection on the key values of the ...