DSXchange

You don't need a header line. Just test the file size. If it's zero, delete tile file. You could do this with DOS commands or with a custom DataStage BASIC. Something like this: FUNCTION DeleteFileIfEmpty(FilePathname) OpenSeq FilePathname to hFile Then Status vFileInformation From hFile Then vFileS...

I had assumed you'd set the Extended property, since you were already talking about microseconds.

If it's already in production, and working, why are you asking the question? If you worked with me, the rule would be "nothing is ever changed in production" - a proper software development lifecycle is followed.

Use an after-job subroutine (for example) to test the file for zero length and delete it if that is the case. If your file has a header line, check for file having just one line.

Welcome aboard. I'm sure there are DoD installations - they have every bit of software ever created, after all! Last year I was involved in installing in Australia's DoD, though this was on AIX rather than Windows. But I am aware that other parts of Australia's DoD does have Information Server insta...

Better than that, our delightful weather permits two seasons per year. I'm currently playing my 104th season. Started in 1958.

Then use a server job, where you CAN do a range lookup.

Relative performance between Lookup and Merge stages is irrelevant, because they perform different tasks.

Start by describing, in English, the algorithm that gets from the input to the output. For example, how does A A C come about?

Then answer the "why" question. This would be much more easily accomplished using two Transformer stages, it seems to me.

You need Final Delimiter String property, not Final Delimiter, which is for a single character delimiter that might occur between the final column in the record and the record terminator.

I don't think this is possible using DataStage, but it would indeed be possible using a script.

The ODBC calls will require an INSERT statement with parameter markers.
SQLAllocEnv()
SQLAllocConnect()
SQLSetConnectOptions()
SQLConnect()
SQLAllocStmt()
SQLPrepare() and SQLExecute(), or SQLExecDirect()
SQLRowCount()
SQLError()
SQLFreeStmt()
SQLDisconnect()
SQLFreeConnect()
SQLFreeEnv()

Try or or

I assumed you'd use a separate stream for each style of processing, given that their rules differ. To generate multiple records, create a lookup containing just a list of dates, and do a range lookup between the max date from the data and the current date.

Neither. Neither engine has its own process. The DataStage RPC daemon listens for connection requests from clients. But, if DataStage is running (that is, has been started), then dsrpcd will be running. You might also like to use netstat -an | grep 3153[1,3] to determine whether the node and logging...