DSXchange

Example:
Declare the data type in DataStage as VarChar with precision 4000.

Keywords of the language are documented as NOT being case sensitive.

Arnd, try SLEEP 31 or SLEEP 33. If that also fails, try calculating the time 30 seconds hence, and sleeping till then.

Why do you think you need to do it from a job sequence - particularly given the earlier responses? Use an ExecuteCommand activity in a job sequence. DEL /F filename && touch filename The touch command is in the DataStage bin folder; you may need to specify it fully, for example DEL /F filena...

Syntax comes up red because the entirely valid system variable name @AM is not in your DSParams file. You can use @FM instead (it's a synonym, and is in the DSParams file) or you can edit your DSParams file to add @AM to it. Your routine or expression will compile successfully even though it is red,...

The server job answer is easy; you can set this hard limit in the Constraints grid in a Transformer stage.
In parallel jobs you don't have this functionality, so need something downstream on the rejects link to count the number of rows and trigger abandonment of processing.

No. BCP is purely a server job stage.
Try the SQL Server Enterprise stage. (Or is it Sybase you're using?)

cheerfu1 wrote:Where can I get job sequencer in DS 4.0?

You can't. But you can create job control code, which I also suggested.

Your job sequence must have, as a very minimum:

I believe yours does not.
When it does, and the Execute Command activity's properties have properly been filled in, you can do what was described above.

Don't know. As a workaround, wrap your job in a job sequence or in job control code, and invoke that from dsjob. The wait does work reliably there. You can manage the deletion from the same job sequence.

Do you have an upstream Execute Command activity? Without that you won't see anything.

Provide the table name as a job parameter.
Run the job in multiple instances, one per table.

In the DataStage home directory is a file called uvconfig containing a heap of DataStage configuration parameters. UVTEMP is one of these. Its value is a directory used for various kinds of temporary file by the DataStage run machine. From the operating system you can execute a command such as `cat ...

Tell us exactly in what way it doesn't work properly. The 7.5 readme mentions that dsjob puts the job status code on stderr. Did you take that into account?

Calling routines like the ones Kim mentioned from parallel jobs will require the use of a BASIC Transformer stage, or working through before/after subroutines.

There is no way to insert a row into the top of a file without involving a second file. Yes it can be done in BASIC, but it's probably easier to do using operating system utilities. If your original file is file1, echo topline > file2 && type file1 >> file2 Optionally follow this by renaming...