DSXchange

Look at the top of this screen, where there is a small menu. Search is roughly in the middle of the top line of this menu. Click there to open the ability to search this forum. Enter orchoracle as a search term and click on Search. I am neither a vendor nor a reseller of DataStage. Ask your vendor t...

Use head tail and wc -l to strip off the header and trailer lines.

In that case you CAN use a Wait For File activity. Then an Execute Command activity to run a UNIX-based unzip or - alternately - use the same command as a filter in a Sequential File stage.

There's no question there.

Go for it. All the information you require is available through the DataStage API.

If you kill the job processes on the server, they will never get the chance to update their status values (which are read by the Director client) and so will appear to remain in a "running" state.

DSAbortToLog aborts this job, not that job. If you are using job control, use DSStopJob on the attached job.

Not really. Once you have table definitions you can save them into the repository, and there you can view them as standard, COBOL, or OSH schema (if parallel licensed). But DataStage can not discover what columns exist in your data. The closest you can get is importing a Sequential File definition, ...

"Compilation complete" indicates successful compilation.
You have neither errors nor warnings in what you posted.

Put the expression back in, try compiling, and post the output from the compilation.

DB2 is complaining that you can not access the function CGIDW.DIWA_MASTER - this could be privileges. Check with your DBA. "Reason code 4" may be useful for the DBA to know.

...and the zip file will arrive in a UNIX directory?

The problem reported is not with terminators. It's with quote characters. Looks like there's a quote character in one of your data columns. Find it and fix it (in the previous job).

Use ExecSH in a before-job or before-stage subroutine to invoke echo (with redirection of stdout) to write the heading line.
In the Sequential File stage set the write mode to "Append to existing file"

You can, by invoking TCL from the command line. cd project_dir && . $DSHOME/dsenv && $DSHOME/bin/dssh "SELECT * FROM RT_LOGnn WHERE TIMESTAMP BETWEEN '2006-04-01' AND '2006-04-05';" But, as Arnd suggests, this is not future proof. In the next release ("Hawk"), job logs are ...

Challenge the restriction!!! It's stupid. Demand reasons. Then post them here - we could do with a laugh. Will they allow job control routines? A job control routine would be a more appropriate mechanism than a before/after subroutine. To use the BCI functions your client will need to purchase a lic...

I have to remove a nut from a bolt. It is very tight. My client insists that I use a screwdriver. Please help. There are two choices, neither of which uses DataStage AND HTTPS. The script that does use HTTPS can be executed under DataStage control, of course, but is - and remains - external to DataS...