DSXchange

Cure: simple supply and demand. Supply more memory or reduce overall simultaneous demand for memory.

Remember that DataStage processes do not necessarily run under your ID. Specify the full pathname of the dtexec command in your BAT file.

Export the project and search in the DSX/XML file. Or query the Repository. SELECT NAME FMT '40L' FROM DS_JOBS WHERE JOBNO IN ( SELECT OBJIDNO FROM DS_JOBOBJECTS WHERE OLETYPE = 'CCustomInput' AND EVAL "@RECORD<14,1>" = 'dataset' AND EVAL "@RECORD<15,1>" LIKE '%<<Data Set nam...

Welcome aboard. Server job questions should be posted in the Server Edition forum.

There are tutorials that ship with the product. Have your employer enrol you on IBM or third party instructor-led training classes.

dsuser08 wrote:If I have to use Full-outer or Right outer or Left outer and capture rejected records,Which component should I use.Please help.

What do you mean by "rejected"? If you do a join in SQL, where are the rejected rows? DataStage is no different.

As both the machines will be having an voc for the hash files being ftp'ed there will not be a problem i suppose. If both machines have a VOC entry then both machines have the hashed files. FTP one structure over the top of an existing hashed file structure can introduce corruption. FTP, like all o...

There will be some upper limit to the size of numbers you can convert using ordinary arithmetic, depending on your EXACTNUMERIC setting. For numbers larger than this you can use "string math" (SAdd(), SMui(), SSub() and SDiv() functions). You need to build a "remainder" function out of SDiv() and SS...

Welcome aboard. When you get around to posting your question, please do so in the appropriate forum. For server jobs there is a specific forum called "IBM DataStage Server Edition".

A local container is local to the job, is a property of the job, and has no visibility outside the job. Its function is to hide some of the complexity of the design. A shared container contains a re-usable sub-set of a job. It can have its own parameters. It is stored as an independent component in ...

To paraphrase Craig's post, your data break the rules for a CSV file. If a data field contains delimiter characters, then that data field must be quoted.

Do you have appropriate permissions in the DataStage project directory, appropriate privileges to the XMETA database, and appropriate credentials for Information Server?

If memory serves me, ^] is the Esc character. You can specify this as 027 (its ASCII code, in decimal).

Can you actually select the test folder, so that it appears in the Folder Path field?

Please provide the exact syntax you used for string_trim(). It works OK for me on version 7.5.1A on Linux.