DSXchange

What kind of numeric did you redefine this column as? Does it have 2 decimal places? It is better to keep this as a text column and then apply a datatype conversion to decimal (StringToDecimal) inside the job. Basically the error is that "100.00-" cannot be parsed. Perhaps it is the trailing zero - ...

Which Stage(s) are you using? And do you have NLS enabled?

Pongal,

you need to talk with your DBA about this, as the message states the process cannot allocated Oracle EXTENTS.

Nripendra,

the Copy stage is to make a copy of data and give you the option of specifying the number of columns to send down each link, but not the rows. There are other stages that do that.

Hello Kumar,

Either you have the job open in a Designer, or you have the Director open and are in the log detail view for that job or the job is running.

Mark, converting an Integer date (in Julian date format?) to a date and back to an integer should give the same result. The conversion between types needs to know the source and target formats, otherwise it won't work correctly. Do you know your source date format in integer? Why do you need to conv...

pongal,

Iconv/Oconv don't work in Parallel extender. You should use StringToTimestamp(in.DateString,[optional formatting])

... ...when i run job, job works fine but when i concatenated 9 columns at that time it gives output upto Name(Column name) I am not getting what is going on ? please help me urgently to sort out my problem. OK, So you read the columns correctly from DB/2 and have a problem concatenating them. I do...

ewartpm, instead of going into great detail, I would recommend monitoring the system when it "starts paging itself to death" and stopping DataStage. If the swapping does not stop then DataStage cannot be (directly) at fault, since it is stopped and has freed up it's memory. There are excellent tools...

When it comes to killing jobs, we in the business prefer never to terminate with extreme prejudice (kill -9), our sanctioned kills are the more discrete "kill <pid>". Sometimes rogue processes need the TEP approach, but usually by the time we get sanction from above it is too late. The director "sto...

Pongal, you could write a function that returns the number of rows processed in the last run of a job, use the DSGetLinkInfo() routine and give it the stage and link name and it can return the number of rows processed. This number can then be used to update either a Hashed file or a table with the n...

dh_Madhu,

go into your sequential stage, columns tab. Right-click on the column in question and "edit row" will bring you to the screen where you can choose all sorts of attributes for columns, including the one you are looking for.

Amos, it might be template issues. Did you do a VERIFY.SQL ALL on the system with no errors - this might be a more likely source than corrupted template files.

C'mon Ray, cut the poor gent some slack; he said it was only a "A little urgent", not a fully blown condition RED national urgency. Just imagine if some bad guys from the feared INFA agency had you tied down on a chair over a pool infested with ravenous piranhas and they said "give us the DataStage ...

Roy, I understand what is happening with the licenses and the warnings; my question is whether DS shuts down after a while due to this condition, here it has happened twice about 5 days apart. All the other boxes that have similar configurations but no license warning haven't had this memory problem...