DSXchange

Hi, These are steps I am following 1. Create a parameter set prm_x 2. Create a job and add parameter set prm_x 3. Update parameter set prm_x. Eg: Add new parameter 4. Click on view parameters in job. Parameter set is not updated in job 5. Remove the parameter set in job and add it again. Parameter s...

Congrats Craig!

I wanted to avoid conversions as they are giving lot of confusions. adding 10000 is a great idea. will go ahead and use this. Thanks

Thanks. We will go ahead and use copy stage as the source and target are passive stages.

We have a requirement when we have to concatenate a value to integer.

Input is 1999
Output should be 11999

How to concatenate this?

Hi, I have only two stages in a job, source as sequential file and target as SQL Server. I need to know if we have to use copy stage in between. I remember that we were using copy stages in between any two sources (even for seq file to dataset or seq file to seq file) where there was direct mapping....

Thanks Ray! That was of great help.

This file is needed by other teams for processing in other softwares. Hence dataset option is removed. The next step is load into data warehouse. Before loading, we have many stages as per business need. I am quite new to Datastage. I read about the properties "Number of readers per node" ...

Hi,

We have DB2 as source and want to put this in some temporary file and in the next step, read from the file. We will processing more 5 million records. Which is the better approach? To store it in CSV file or Flat file or delimited file?

Thank in advance,

Thanks... This really helps

Hi,

I have a table like this
E.No Salary
1 1000
2 2000
3 5000
4 4000
5 1200

I want top three employee numbers who have maximum salary. How can this be acheived?

Thanks,
Anitha

Its not required to trim varchar columns. In case, if column C has CHAR datatype, then trimming is required

You can get the link count in after job routine using DSGetLinkInfo function

DSGetLinkInfo(jobname, stagename, inlinkname , DSJ.LINKROWCOUNT)

Thanks Sainath for your reply
Source is from COBOL structures. As said, it gives -1 for 111b. How should I proceed. We dont have access to premium content

Hi, I'm reading decimal data using sequential file stage in fixed width format. No signed bit is assigned. So, Packed= no (zoned) is selected. For decimal(4), if data is 111a, then data is not rejected. Instead, its read as -1. If data is 11a1 or 1a11, its getting rejected correctly. When the last d...