DSXchange

You need to check every column. The Format tab of your Sequential File stage specifies that "" is to be understood as NULL, so you need either to change this or to check using the IsNull() function. Another possibility is to read the file as if it contains just one large string column, and then to u...

If the input date is already in YYYY-MM-DD then the solution given is non-optimal. All you need to do to get YYYYMMDD is to strip out the "-" characters. Some possible solutions are: Trim(inLink.TheDate, "-", "A") Convert("-", "", inLink.TheDate) Oconv(inLink.TheDate, "MCN") inLink.TheDate[1,4] : in...

The ODBC standard forbids spaces so the ODBC driver enforces the rule. That MS Access does not is just Microsoft not following its own standards!

About your only choice is to use user-defined SQL. Let DataStage generate the SQL and then modify it.

Create three files with DataStage - header, detail, trailer. Assemble them subsequently with the UNIX cat command.

Server jobs are extremely flexible, don't require a lot of thinking to build. But, like any endeavour, to be done well they do require some planning and preparation. Have a source-to-target mapping document. Have your metadata already in the Repository. Parallel jobs require slightly more preparati...

I don't know the answer to your question, but I agree with your expectation. Did you have a sample size set anywhere that might have limited the reported number?

Funnily enough, and despite what Oracle bin Larry would have you believe, there are other databases than Oracle. SYS.MESSAGE is a UniVerse table. You can query it from the Administrator client Command window, or from a TCL prompt. TCL is UniVerse (DataStage) approximate equivalent of Oracle's sqlplu...

"ISO format" for dates means ISO 8601, which is an international standard for how to format dates, timestamps, times. The standard date format is YYYY-MM-DD. ISO8859 (various parts) is a standard relating to encoding of characters, and is irrelevant on this thread. NLS character maps don't come into...

-14 is an error code from DSRunJob, not a job exit status. It indicates that some resource could not be obtained within the required time. The job status of 3 is "Aborted". The reason is "timed out waiting for event" (the "event" may have been for the job to start, or to acquire some resource, or to...

There's no ON ERROR clause for the OPENPATH statement in Arnd's code, yet this is where a system error is most likely to occur. And I consider any use of DSLogFatal (or STOP or ABORT) (...or CHAIN) to be sloppy programming. clearfile (in the DataStage bin folder) can be run from the operating system...

I've done this with PCs in Bangalore (India) and the clients in New York, and it was fine (except when the power went off!). Version 7.1.

Plug-in stages can only be installed on the DataStage server. You use the package installer (dspackinst script) to achieve this. If there is a custom GUI, then you install this on the DataStage client machine using a standard InstallShield setup.exe program.

FTP the copybook to the AIX machine.

From Manager, choose Import > Table Definition > COBOL FD.

Note that you have to tell it (the import wizard), accurately, in which column position the LEVEL 01 item resides.

Done.

It may be that it tours next year. India is not out of the question. This is neither a promise nor an undertaking - ultimately it will be DCS's call.

In the USA, use MDY rather than DMY in the expression.