DSXchange

Prasanna2100 stated that u can go to UNIX kernel and KILL a running job from there . This statement is correct, but along the same lines you can also go to your server and pull the power plug; that will stop the job running as well. Doing either may result in more problems than you had when you star...

ISNULL(String1:String2:String3:String4) will return TRUE if any of the strings are null - this query would be more efficient than your initial OR ing construct. But you don't need to do that in this case, since you only return a 'Y' on a specifi condition, so a better form of your code is as follow,...

Use "{JobName}.{InvocationName}"

But each run of your job will have @OUTROWNUM starting at 1 and counting up and this method will generate duplicate keys....

Nitin, I took a look at your job (that project name was too familiar). Your source dataset has the column defined as CHAR(1) while in the database it is declared as a CHAR(8) and you have no modify stage or handler. Also, you are not doing a rejection stage coming out of your DB/2 stage to see if th...

Amit, it is a lot of work to put together a documented case of using a CFF with an example of copybooks and stages and that is really not the scope of this forum. The CFF hails from COBOL type data layouts and is most often used in that context, but can be used with other types of data. Let me ask y...

I'm not at a DS client to test this right now, but have you also specified the display width as well - as needs to be done with sequential files with fixed width?

Deepesh, use the builtin debugger in the Designer to go through your job's execution row by row to find out where your null value is being inserted into your data stream.
I hope this answer was taken with the high priority you expect for a non-charter member.

It usually helps quite a lot when you know which HW and which language generated the file - i.e. with Cobol when you have "garbage" you can try an EBCDIC conversion to see if it makes more sense, and if that doesn't work you know that the binary is probably going to be some form COMPutational format...

Chandra, even though Ray's answer is by far the easiest, there are a number of date functions available to you by using the OCONV function and the "D{options}" Date conversion. You can get your date formatted to WWW or even to the Chinese year names if you want.

You can use the derivation fmt(right(In.Column,10):"00000","15'0'R") to do what you asked.

If yopu can execute this SQL statement with your query tool, then you can do so in PX as well.

What is the data defined as in the column page (type, length) and what did you set the fixed width to?

If you look at your job join stage "Join_28" is there a column called "Rate_WA" on either the input or output side? Is it part of your join key?

The Iconv and Oconv functions that do date transformations also return status codes telling if the conversion was successful, successful with warnings or unsuccessful. Using a mask of yyyymmdd the value of "00000001" would return an error, while "00000101" is a valid date.