DSXchange

What exactly does "ignore 6200 event" translate to? Don't write it to your output? And are we literally hard-coding things for these "event codes" or would it be more proper to mention the first v. the second v. the third?

Construct an otherwise static date from your month number, then StringToDate() followed by DateToString() using just %mmmm for the format mask.

You have a closing tag, a valid one but just not the one you think it needs to be. You can change the option from <tag/> to <tag></tag> but they are equivalent.

Do an exact search here for "DS_AUDIT" and see if that is what you are looking for. Hopefully it is!

Or compare against a string of all spaces.

... something that would require a wrapper script to accomplish.

Wasn't even gonna go there.

An exact search for "ParamValue/Limitvalue is not appropriate" will tell you what is causing that.

OK... when you set the field to NULL (not a space ) it will show up in the file as whatever you put in for the null value - in this case as your 'required space'.

Then you missed something. Tell us exactly what you did to correct this - how you made sure the output field was null at the right time and what exact properties you set for that field.

35 isn't going to cut it, as you are seeing. I'm guessing it will need to be much higher, especially if your jobs all connect via the same user. And you set that on the Oracle side, not in DataStage. At a high level - take the number of the Oracle stages from all currently running jobs and multiple ...

ajithaselvan wrote:It can be nullable. But it can not be representated as string.

Actually, everything in a file is a string so it can. Set it to NULL and then edit the column so the 'null value' property is the appropriate number of spaces.

Ajitha S - please don't post in all capital letters, it is considered SHOUTING. I corrected your post Subject for you, so more of just an FYI. Thanks.

srinivas.g wrote:set $apt_oracle_preserves_blanks is true and try....

Haven't seen any mention of Oracle yet...

ajithaselvan wrote:I need to populate space to the output column.The data type for the column is float(2,5). Kindly help me to resolve.

The answer is simple - it cannot be done. Get a new requirement... for example, is the field nullable? Can it be represented as a string?