DSXchange

Use stage variables to capture the column values from previous records. This has been discussed many time sin this forum. In transformer stages after v 8.5 you can also user a loop or maybe some of the functions. If you need it for lookup with the same dataset - self reference, copy the dataset ( or...

you can include it either in a routine activity stage ( use custom trigger in the activity o/p link) or , what may work better is to use an user variables activity - In case you need to pass the output of this routine to another downstream activity .

There is a document called datastage programmers guide that can help .

Haven't reinstalled the 7.51 A client , Just open director witha different job category showing; as it would require re installing v 8.7 client and a multi client manager - not enough time to go through that pain right now. A search on IBM site (alt+w) may help . The OP can attempt to open a differe...

Thie is not just an Xmeta error. I get it with datastage 7.5 client also. Its a visual basic error with some sort of repository corruption issue that interferes with the working of datastage clients.

I Downloaded the whitepaper and compared it to the 'talentrain' website. This is so atrocious.
Forget word to word copies, even the images are bitmap copied. Using a PDF to word extractor and then composed as a HTML page.

Did you verify XLC/C++ v 12.1 is supported in any version of datastage 8.x ? I was about to download it , but it was not listed as a supported version for datastage version 8.7 FP1 that we recently installed. The max supported version was XL C/C++ version 11.1 ,and you can download that only if you ...

post Deleted as duplicate.

Arndw: Will you not need 2 user variables ?

did you check if there is anything in the $HOME/.profile file of the user id ( unix id ) used to run jobs in the troublesome project ?

How many recipient email ids are being sent to ? Did you define the default mail server name ? Are there any other jobs with notification activity behaving correctly ? Is the sender email id being filtered out ? The answers to those questions may help clear up the fog.

Old Post . But Im tempted to leave a reply . We have Datastage Mainframe edition , I can create a job to read and IMS file and convert it to a fixed width or delimited flat file. First you import the DBD ( database descriptor ) and PSB ( Prog spec block ) using IMS def import. You get a schema view ...

Uppercase & Trim data on both links just for the Lookup to happen ( requires use of transfromer stages or db functions) .

The ORABULK stage ( Oracle 7 Loader ) is supported in Version 8.7 . It is documented in the server job developer's guide of Version 7.51. Not in the Connectivity guides of V 8.7.

We have between 30 to 40 jobs in datastage 7.51 A that use the old ( and possibly deprecated) Oracle 7 Load stage :( , yes Oracle 7 Load , seven as in seven boo hoo.. Is there any way they can be migrated to Datastage 8.7 ? Shoudl I convert these stages prior ti migration. The OCI 8 To 9 B routine s...