DSXchange

A Batch in DataStage is job control code that is created using the Director client.

Post your job design - with stage names - and your routine code, so that we don't have to keep guessing.

Was there something in my previous post that wasn't clear?

Yes.

Search to find examples of the requisite SQL statement.

I dont want to pull the records from the database and send the old value if there is NULL in the sequential file for that column. Tough. That's the only way you can do it. Consider methods, such as a "bucket file", that you can use to limit the number of rows that you need to bring in from the targ...

Kim, Thanks alot for providing the SQLs. Answering to Mike, it's a policy in my organization to collect number of lines of code used in all the projects. This is basically to measure how much coding has been done. Unfortunately (or fortunately ) DS doesn't have code in lines. So we thought of provi...

You should be able to use the Convert() function. ^C is Char(3), ^H is Ctrl(8). Construct a list of control characters in a stage variable, and use Convert() to replace that with "".

Yes. Same rules as SELECT in SQL.

You have marked the job type as server. APT_BUFFERING_POLICY is not applicable to server jobs. What job type is it really? What value are you giving APT_BUFFERING_POLICY? There is a bug in some releases where the drop down list does not provide legal values (they are not correctly cased). The workar...

What Arnd advised is correct. As far as I am aware there are no plans to recognize certification by means of any reward on this site.

Stop thinking script, start thinking job sequence. A master control job sequence can be started from your script, and then manage the rest. Once you're in that environment you can much more easily use the DataStage API. DSGetJobInfo() can be used to obtain a list of the parameter names associated wi...

How do I transfer (or re-post) a post in General to Server? You can not once it's been replied to. The moderator can (will?) relocate it. Or you can start a new thread in the appropriate forum and post a message here referring to the new thread as the correct location for responses. It's easier for...

When you use a SUM function, DB2 automatically gives you a data type twice the size of the source column - in your case Decimal[31] instead of Decimal[15], so that no arithmetic overflow will occur. You have to specify this data type, or explicitly handle the data type conversion within your job des...

There's an internal inconsistency in what you wrote. I must assume that you want to override the value defined in the Administrator client with some other value obtained from a file. There is no problem assigning a new value to an environment variable; you can use the set command at operating system...

What about where the file does not exist, but is nonetheless opened for writing? What about where there exists a record level lock on the file taken by another process? As I said, there are very many possibilities, which is why the OpenSequentialFile routine exists.