DSXchange

This is more along the lines of a buildop in PX. If you can use server jobs then you could do some string manipulation in a loop, I'd use INDEX(In.Col,' OR ') to find the "or" statement, then go back 3 words and prepend a '(' and then go forward 3 words and put in a ')'. That approach is straightfor...

Can you perhaps explain exactly which stage and what columns you have? Are AAAAA, BBBBB, CCCCC column names?

Can you set your environment variable for $APT_MAX_TRANSPORT_BLOCK_SIZE to a higher value to accomodate this string size.

Are you doing a sparse lookup or a normal one?

Do you get the same error if you try it with a smaller length, i.e. 100,000?

If it is present in the dataset schema then you are left with the link coming from DB2. That is supported by the error message noting the "key" field is missing.

declare the order to be "insert then update" and if you only have inserts to do then the update clause will not get executed.

Transform stages can take a long time to compile. This time can also depend upon how many concurrent users your c++ is licensed for.

Search the documentation or DSXchange for "dsjob"

That is the most likely cause. Can you try to FTP the file(s) manually to see if the connectivity is there?

The function you would use in a PX transform stage is "DateFromDaysSince", i.e. . Note that 180 is only a banker's half year, 182 is closer and that leap years might need to be accounted for as well.

Gerald sui wrote:FTP_FMSSourceFile,0: Internal Error: (0 != ports): subproc/gsubproc.C: 2493 ...

It looks like something to do with your FTP stage and the input/output ports. Are you doing anything special in your FTP stage?

gnan_gun wrote:not resolved as per your syntax

That was inordinately unhelpful. There are numerous ways for things to not work - if you don't tell us what happened then you cannot expect an informed answer.

Questions: 1. How internally DataStage Server engine functions in the respect of UniVerse, Basic and DataStage? How these components are interacting with each other when a Server Job is designed and executed? "UniVerse" and the "DataStage engine" were identical several years ago and have now got di...

It seems that DS is inserting an active stage before the sequential file. Try adding a dummy transform stage to see if this behaviour changes. I assume the stage leading to the output is a passive one - is that right?