DSXchange

Actually, the first impression of the sample data put me off, as to no sort criteria was specified. Craig, i looked into the sort specifications and you are right, a collating sequence map (a csv file) can be maintained to specify the weight of each character, which is read by the sort stage and imp...

Thats not called sorting. Based on what conditions will you decide how to sort. The info you have given is not enough to build a design or code.

try to give it as


Just try. Me not well versed in windows : (

OR
Try to give it the same way you are feeding it, but set the type to string instead of filepath.

Look at Ken's routine in this post. Tweak it to replace the line terminator with some other character. And then at the end, do the same in opposite fashion.

In the sequential file stage, in the columns tab you have a column "Contains Terminators", set that to Yes to every column that has multiple lines.

I doubt it. During run time the engine will complain something like read_seq error due to line terminator encountered before the end of the row. You can certainly handle it, yes but not maintain it like that. Maybe in place of a lineterminator you can put some other character and during the end proc...

Offcourse you wont be able to open it. The timestamp will have a space in between and unix doesnt like that.
Use this

Opps, sorry, its with a small 's' in Timestamp.
try
OrderInvoice#DSJobStartTimestamp#.txt

You are attempting to write a null record in the key column. Try handling null. Like in the constraint put

What error message? How exactly are you using the job parameter ?

In the sequential file stage, use macro DSJobStartTimeStamp
OrderInvoice#DSJobStartTimeStamp#.txt

I am not exactly sure if this functionality is available in version 5.

See! I told you I need classes. When shall I enroll ?

Count me in too

Actually the answer to your query really depends upon what exactly your dsjob.exe is doing besides running jobs. If its getting log files and they are huge, then there you go, thats whats taking time.

I just woke up, i missed all the fun, whos teaching english again, i wanna enroll