DSXchange

Yes. Search for the 'How to' part.
No special steps. Make a copy of the dsenv file just to be on the safe side. Make changes. Stop engine. Start engine.
Make sure no one is connected to the engine at that time. You dont want angry folks on your back

IsNull() is to be used in a conditional statement. Like

IsNull() will return a numeric value. What have you defined the stage variable as?

And what was the issue?

That means you were not giving the format properly or something must be missing. By default its taking YYYY-MM-DD format. Nothing to be confused
One thing though, make sure the Juilan Dates got loaded properly.

DO an exact search on 'SQL27959N'.

I highly doubt its a commit level issue. It was just the timing at which your job ran. The table was locked by another process/session. Run the job again and see what happens.

I dont think its possible in a one line in a px transformer. Primarily becuase of the presence of the word 'Valve'. A CONVERT() on this word will force conver the letter 'V' everywhere in the string. Go back to the folks and tell them its not possible. If I absolutely have to, I will use a server jo...

madhukar wrote:100 Marks....!!!!

Do I get a golden star too

I thought I gave you a C routine for that. Isnt that working? Or you want to keep everything a one liner?

If this is DataStage log then it would be nice to post the exact error message.
If you suspect its the commit level then there are two environment variables that you can set to control commit levels. Namely
APT_ORAUPSERT_COMMIT_ROW_INTERVAL
APT_ORAUPSERT_COMMIT_TIME_INTERVAL

What led you to believe that the table was locked? or your process was deadlocked? If you job hangs then I suggest getting together with your dba to see if the connection even reaches the table and whats happenening at the database level. There might be live threads out there with your id which migh...

Set you final delimiter to end. Also the thickened pipe that you are seeing is CR, ascii (013). I bet this is a dos file that you ftp'd over in binary mode. Ftp it again in ascii mode so that the CRLF gets converted to LF (dos to unix) formats. Or find one of the many sed/tr/awk commands to convert ...

The second one can be handled by putting an outher CONVERT() statement to convert 'Liter' to 'L' but the first one is a challenge. THe one liner code will become very messy. It already is. I suggest write an external function so that everything is well explained and its easy to know whats going on.

I would opt for sed/awk script. That would be much easy and the code wouldnt be huge either. There are many sed one liners that perform similar tasks. The script would even be independent of the files metadata. Look into it.