DSXchange

Before-job ExecSH command:
Then in the job only read the one new file, #$DATA_DIR#newfile.txt.

Importing objects from newer version into older versions is not going to be supported and should generate errors. Do it the other way around.

#$DATA_DIR#file?.txt

Wildcards:

? should match 0 or 1 characters.

* should match 0 or more characters.

Use the Merge stage instead.

I would think you can by using the Sort stage key change column plus Transformer stage.

What data type is it?

Try ODBC --> Peek stage.

Use the file pattern option in Sequential File stage to read all 4 files into the same job that inserts using DB2 Connector stage.

Have you read the online help / product documentation?

Please ask a specific question.

Add a final Sort stage with the key change column based on sort key = ID. If your key change column is based on sort key = st_DATE then you'll get a lot of 1's and not a lot of 0's, for every time st_DATE changes values.

That's an excellent idea.

In Linux/UNIX, date arithmetic is not going to be as easy as using functions already built into DataStage. You can use the date command with format options, but subtracting days from a current date will pretty much force you to build your own calendar logic for going backwards across months and year...

Try a command line ftp connection directly from one server to the other. Get or put files. That would give you a direct way to transfer data. Indirectly, you could ftp data from dev server1 to your PC using some free ftp client like FileZilla. Then ftp from your PC to dev server2. If you're asking h...

Suppose your data set is already partitioned by EMPLOYEE_ID and you need to sort by EMPLOYEE_ID and DATE_HOURS_CLAIMED. The data set does not also need to be partitioned by DATE_HOURS_CLAIMED.

The way I read it, there's normally two commas, except when there's only one comma.

Use If Then Else based on the result of counting comma delimited fields using the DCount() function.