DSXchange

We are migrating to Datastage 8.5 from Datastage 7.5. In Datastage 7.5 we have jobs which use oracle Database using enterprise stage and we also have sequencer jobs in 7.5 parallel environment. My query is can we upgrade directly to 8.5 parallel edition from 7.5 environment, if yes then what is the ...

Sorry for not being clear on my requirments. I need to perform a lookup on the same table which I am Inserting/updating using upsert in the same job. design is: source ---> lookup tartget ----->Insert/update target Say source has 2 records EMPNO ENAME 7368 DEV 7369 SMITH 7369 SMITH My requirment is ...

Hello, I need to lookup on the same table which is being updated/Inserted in the job. My business requirement can't support me to break the job and do update/Insert in separate job. What design I should use for achieving the desired result. 1). Is the updated records from source being looked up for ...

Please try the below config file. I think you placed brackets at wring location so it is reading only upto first node and ignoring node 2. Changed Configuration File { node "node1" { fastname "TOMEDW" pools "" resource disk "C:/IBM/InformationServer/Server/Datasets...

Please try the below config file. I think you placed brackets at wrong location so it is reading only upto first node and ignoring node 2. Changed Configuration File { node "node1" { fastname "TOMEDW" pools "" resource disk "C:/IBM/InformationServer/Server/Datasets...

Please try the below config file. I think you placed brackets at wring location so it is reading only upto first node and ignoring node 2. Changed Configuration File { node "node1" { fastname "TOMEDW" pools "" resource disk "C:/IBM/InformationServer/Server/Datasets...

...When I check the file on unix machine in hex format i can see the values like: 0100265100 0107313300 and so on.... Is this Hex 0x01 0x00 0x26 0x51 0x00 for the first row? If so, something is wrong. Do you have the actual COBOL picture definition for this column? thanks again Arnd. Yes these are ...

the values of "01 00 & Q 00 80" do not look like a valid COMP-3 field value, regardless of whether it has a leadin or trailing sign. Are you certain that you haven't done an EBCDIC to ASCII conversion here? Thanks Arnd. I have not done any EBCDIC to ASCII conversion. Input file is FTP...

Hello, I am using CFF stage for reading a multiformat file. File type is binary. Char set is EBCDIC as FTPd from mainframe. I need to unpack data of a packed decimal field from a binary file. The field takes 5bytes. I have used data-type as DECIMAL(9) in CFF stage and I can see it's cobol format sho...

The issue has been resolved. need to change the entries into DNS server to new one (NEWIP) and restart the server.

Thanks and Regards,
Sachin

Hi, we have Datastage enterprise edition 8.1 installed on AIX system(some IP Address say OLDIP) and now because of some IT planning need to change the existing IP address with new IP address (say NEWIP). My server name is same only the IP address is changed. After changed IP Adress, When I checked t...

Hi All, I am trying to install Datastage 7x (Windows) on OS Win Server 2003, but while installing I am getting following error (I am trying fresh installion, no older version was present) MKS toolkit error was:536870918 Win 32 error was:1619 Please let me know how to resolve this error. Thanks &...