DSXchange

If your source is a DBMS, then you could join the source table to another table in order to get the number of rows you require. Eg. select a,b,c,d,e,f,g from source_table x, other_table y where x.field1 = Note there is no join condition between source_table and other_table, i.e. a cartesian join. If...

Im not aware of any reason why it should not work. We do it frequently through ORAOCI8 stages. Must admit I have never used DataStage 6 yet, so I dont have any experience with the OCI 9 stage. When you say it doesnt work, what are the symptoms? Does it fail? Does it run but return the wrong value? -...

Hello All, Can anyone of you guide me to get the next value of a sequence using OCI 9i stage ? I used the same query in ODBC stage it works, But not in OCI stage. Following is the sql SELECT PSN_PRIMARY_SEQ.NextVal FROM DUAL Thanks, Shiv ______________________________________________________________...

What release of DataStage are you running, and what operating system (and release number)? I suspect that STATUS DISKS is making a system call that, for some reason, isnt handling the fact that E: drive is over 2GB. While I doubt that the errors from the RT_CONFIGxxx hashed files is related, DataSta...

I took an input file with: 1,2,3 4,5,6 7,8,9 In the transform I used:(where DSLink2.a = 1,2,3) for each line: DSLink2.a:CHAR(13):CHAR(10):DSLink2.a:CHAR(13):CHAR(10):DSLink2.a:CHAR(13):CHAR(10) DSLink2.b:CHAR(13):CHAR(10):DSLink2.b:CHAR(13):CHAR(10):DSLink2.b:CHAR(13):CHAR(10) DSLink2.c:CHAR(13):CHA...

This is a topic for an orphaned message.

Hi ksurapan, yes you can. The best way depends on what you want to get. (1) If you want to have 3 different outputfiles => use three outputlinks, one to each file (2) If you want to write 3 lines in one seqfile the use the derivation => OUTPUT=INPUT:CHAR(10):CHAR(10):INPUT::CHAR(10):CHAR(10):INPUT (...

You could also use the normalize option on a hashed file output. Youll need to append an extra column to your source row that contains incrementing numbers separated by a value marker (@VM) up to the number of rows you would like to duplicate. This would then pass through a hashed file where on the ...

Pad the source by adding the same no of attributes as the no. of rows you wish to create and then feed through a pivot stage. Don Walkden -----Original Message----- From: ksurapan@hartfordlife.com [mailto:ksurapan@hartfordlife.com] Sent: 20 January 2003 14:14 To: datastage-users@oliver.com Subject: ...

Hi There, Can you have multiple destination rows for the same source row in a single Transformation? If so can anyone tell me the how? The example is below Source Destination 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 Thanks. *************************************************************...

Hi All, The STATUS DISKS shows %used as 118%. Documentation says its the disk usage. But that drive has 3.5GB free space(E drive). DataStage is installed on E drive. Then what does it mean? We are getting lots of RT_Config errors like Cannot open executable job file RT_CONFIGXXX. Is all these relate...

Hi All I have a user that wants to put DataStage behind their firewall and need to know if there are any default port numbers DataStage uses, as well as, Universe. They are going to be running DS 6. Thanks. Mark Ewart-Phipps Centerfield Software +27 83 380 2335 ______________________________________...

Could you elaborate? Thanks --- Surendranath Gujjala wrote: > Yes. Make use of stage variables. > > -----Original Message----- > From: ksurapan@hartfordlife.com > [mailto:ksurapan@hartfordlife.com] > Sent: Friday, January 17, 2003 3:48 PM > To: datastage-users@oliver.com > Subject: Multiple Outputs ...

Yes. Make use of stage variables. -----Original Message----- From: ksurapan@hartfordlife.com [mailto:ksurapan@hartfordlife.com] Sent: Friday, January 17, 2003 3:48 PM To: datastage-users@oliver.com Subject: Multiple Outputs of the same source Hi There, Can you write out a single row in the source fi...

Hi There, Can you write out a single row in the source file as multiple rows into the same destination file with the same values in the same transformation? If so How? Thanks . ************************************************************************* PRIVILEGED AND CONFIDENTIAL: This communication, ...