DSXchange

NLS_LANG and LANG_C

Change them in dsenv as well as in your .profile script.

Try or (the latter assumes that the job parameter has date as its data type)

This is nothing to do with the use of a schema file or otherwise. What it has to do with is the value you have given to the "Null Field Length" property. When you specify fixed-width format, then the "Null Field Length" (or the "Null Field Value" if you use that) must exactly correspond to the decla...

Mount the relevant directory on the source machine onto the DataStage server machine, and use that pathname.

Reserved for future use? Also, the list of SQL data types is those decreed by the SQL 92 standard.

Pre-process the file using tr or sed or awk to replace all the line terminators within each line (but not at the end) with, perhaps, spaces

Serks?

mab_arif16 wrote:While compiling I am getting an error varbinary dataype not supported does the data stage supports varbinary?

Isn't it obvious from the message?

Use a separate job (maybe even a server job) to do the SELECT MAX(...) query, capturing the result into a file. Use an Execute Command activity in your job sequence to read that file, perhaps using a cat command. Use the $CommandOutput activity variable from that Execute Command activity to supply t...

Yes and no. There isn't a collection method in the Link Collector stage that permits "all from source A then all from source B". The (parallel) Funnel stage has a "Sequence" method that permits this mode of operation.

You seem to have parked it hard on the left hand edge of the canvas. All toolbars in Designer are floating. Can you position your mouse pointer in it when it's visible? If so, try double click to see whether you can release it from its parked position, then you can drag it to where you want. If that...

JCL templates exist so that you can customize the JCL for your particular installation. COBOL source generation is a method of each stage type and is not negotiable/customizable. After all, what would you change? Generic function calls are made to ARDRTLIB (from memory), and the JCL can specify wher...

Can anyone tell me in detail, what all factors need to be concerned for "Extract Requirements of Data". There are some folks around who make a living doing exactly that. They tend to have titles like "business analyst", and produce documents called "source to target mapping" or, if you're lucky, "t...

InvocationID should be in the "job started" entry in the log.

Please advise, when reporting errors, whether kill has been used. It opens an entire extra set of possibilities.

Even better, don't use kill on DataStage processes.

SUBROUTINE DetectAndDelete(Pathname, ErrorCode) * Deletes file if its size is zero ErrorCode = 0 ; * set to non-zero value to stop job * Open file for reading OpenSeq PathName To FileVar On Error * System error of some kind ExitStatus = Status() Message = "System error (cod...