DSXchange

Thanks, much

Thanks, much

hmm..this should be parallel.

Can you tell me what it needs to get it done in parallel

hmm..this should be parallel.

Can you tell me what it needs to get it done in parallel

My input column is A - CHAR(9) with value of 000332422, My output should be 00.0332422.

I used a Decimal(9,7) for my output, but it writes 00.000000.

How do I resolve this?

Thanks, as always

Thanks Ray, but is there a macro like the 'DSJobName'?

Hi all,

I have a requirement to populate one of the target columns with the DataStage generic user name. Can you help me how to do this?

Thanks

Hi all, I have a situation where I have to delete records based on a key. Oracle table as the source with columns DNO - Key DNM LOC I have a Hash file with thye same column definition. I have to delete records from the Hash file based on the DNO - key, so if the Oracle table has 3 records with 10,20...

Once my sequencer job successfully finished executing the DS server jobs, I want to delete the hash files created by the process.

Can you suggest me the best way to do it.

Thanks

Can anyone give a command to kill the job from DS admin?

I deleted this from Site Forum.

The user-ID used is a common ID for the entire development team.

Hi,

Few of my jobs are in "use"(accessed by another user) status for more than 2 days.
How to I kill or release them from the DS Administrator?

Please suggest the command.

Thanks

Occurs clause from the COBOL file. I have a input file coming from mainframe and the COBOL copybook has a table with occurs clause. The requirement is like this, Using DataStage 7.x, if the table OCCURS 2 times, I have to generate 2 rows in the output, i.e. 1 row for the first occurrence and 2nd row...

Hi, I have a file with different record layouts. example - record 1 is of 7 columns record 2 is of 4 columns(not all columns are same as of record 1) record 3 is of 6 columns(not all columns are same as of record 1 and record 2) and the same above set of records repeat. How can I use this file as in...

Yes Paddu