DSXchange

The default for a job sequence is DSAttachJob(jobname,DSJ.ERRNONE).
This prevents propagation of exit status to parent, asserting that the parent's job control code will handle it.

The error means that the number of columns provided in your DataStage job (column metadata) is fewer than the number of parameter markers in the SQL. This may occur, for example, if your DataStage job provides a key column but the user-defined SQL relies upon a sequence to provide the key value in t...

Do you really want to delete the jobs (!), or the log entries associated with the instance of the job?

The function for converting a pipe-delimited array to a field-mark delimited array is, as Ken suggested, Convert (assuming there are no pipe characters in your data). The function for converting back again is also convert. DynArray = Convert("|", @AM, PipeArray) PipeArray = Convert(@AM, "|", DynArra...

On Windows platforms DataStage can make use of "external functions" (exposed from ActiveX controls) as transformation functions. You will find that performance leaves something to be desired. The BCI functions available within DataStage BASIC permit you to access SQL Server (and other databases) via...

The parent job in the sequence may or may not get to hear about it, depending on the second argument value to DSAttachJob() that is generated. Check out the on-line help for DSAttachJob to see what I mean: what the difference is between DSJ.ERRFATAL, DSJ.ERRWARN and DSJ.ERRNONE. Ray Wurlod Education...

More DS users are likely to be familiar with CAST (which is part of the SQL standards) than with EVAL, which isn't the same thing at all. CAST effects a temporary data type change, EVAL generates am on-the-fly value. Yes, I can take a joke (just see my pictures on DSXchange), but I also like to be a...

You can set defaults in the Director (Tools > Options). These defaults are honoured by subsequent dsjob -run invocations.

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518

I can't say without checking. Haven't looked at the sample since release 3.x. Really busy at the moment, so this won't happen soon. Sorry.

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518

Kim,

Not 100% certain that utility would work for PX jobs.

Ray

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518

No facility is provided by Ascential for compiling jobs from the command line on the DataStage server. The CompileAll tool, available from this site, can be used to institute multiple job compilations (via standard Windows multi-select). As for accessing your jobs from the Projects directory, this i...

The technically correct way in SQL is to use a CAST. UPDATE RT_LOG1111 SET TYPE = 0 WHERE CAST (@ID AS VARCHAR) LIKE '//SEQUENCE.NO%'; You can use CHAR or VARCHAR, though with CHAR you will also need a maximum length (VARCHAR has a default maximum length of 254). The LIKE operator requires string da...

Or choose the Grid Style GUI [:D]

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518

You may find it easier to use the log-inspection options of the dsjob command. -logsum returns a summary of log contents -lognewest returns the newest event number of a particular type -logentry returns the detail of a particular entry Ray Wurlod Education and Consulting Services ABN 57 092 448 518

Is 6.0.1 certified for operation on Windows 2003?