DSXchange

Hi Divya, You have sequential file stage, XML write stage, sort stage in datastage designer. Have you tried with these stage to perform your task. If you are not able to recongnize these information, pls go through the document given in the client machine. You can find that in Start-->All Programs--...

Search on this forum will give your more insight. The existing filter option enables you to use Unix command in it. Say for example, if you want to read a file in a sorted order use the filter option sort <filename>| [options] And make the file name to dummy by pointing to /dev/null

Though it seems that the first always get executed first, it may not be sure which will end first. Because both were constructed paralle. Since the generated code should be in sequence, the first one may seems to kick of first, but the execution will not be same as the start. If you want to maintain...

HI and Welcome Aborad :D

May I know the exact need of this. By clicking and making it to run is also a manual process, which is very similar to run from designer by clicking the run button.
DS Scheduling is also a part of GUI event.
Else build a exe (or bat file) which inturns calls the jobs.

HI Sateesh,
If you need to see the replies, you can directly get in to the post by clicking it. But not sure what you exactly need.
Once the post got any reply, it comes goes to the first post in the list.

Are you using Basic code for this.
Then you need to 'SetParam' for each job (handler).

Another thought. Have a Table with the following values.

1
2
2
3
3
3
4
4
4
4....

to the maximum possible value of a3. (Which can be populated even at runtime by finding the max of a3 from TableA.)
Do a lookup to the Table A with a3 column. And get the Table A values.

No you cannot see those replies. Because, there is none as of now.

Well, I can help you searching on this topic.
Search for topic "CRC Info" or "Suggestions needed to improve the performance(Hashedfile)" ....

ArndW wrote:Kumar,

on AIX I have sorted many more records than that. I actually did call a UNIX sort from a DataStage job earlier today of about 48 million records.

Perhaps I need to check for any parameter change required.

Basically, you need to convert into the internal format of datastag (using TimestampFromSecondsSince or TimestampFromDateTime or TimeFromMidnightSeconds or SecondsSinceFromTimestamp.... ) and subtract 1 second from it and convert it back to the required format.

No comments.

Is there any change in data?
What is the data type been used?
I once faced the problem with the APT_PADCHAR property. The file produced by another job was with different padchar and hence messed up.

Why do you want it in fixed width and comma delimted?

EXAMPLE OUTPUT

3. G--
...
...
3. IN 3 rd OUTPUT I NEED TO REPLACE -- WITH BLANK.

For third case, Is it that given EXAMPLE OUTPUT is required or in the 3rd point is required. Or The both.