DSXchange

Yes, the OCI stage does the TO_CHAR automatically when generating SQL for Timestamp fields. That's not the problem... or at least it shouldn't be. Where are you getting this message? It's not coming from the Source stage, but further down the line. Without knowing anything about your job, I'd guess ...

Sorry, but you'll need to help yourself - all we can do is point you in the right direction. In spite of what you are thinking, the error message states you are trying to update a non-existent record. Oracle wouldn't care and would happily update nothing. Informix cares. Double-check your work. Dump...

Or just correct the full path to 'dssh'.

It should, if you are planning on doing this in your script.

Parse the output for a status of zero, which means running. Specifically, the output from the command would be:

Job Status = RUNNING (0)

Is the row of column names is also considered in the rowcount or not? No. I wouldn't suggest something like that specifically to counter the issue of column headings if it wouldn't work as suggested. Trust me. As noted, you are checking the link that is sending data to the Sequential file, counting...

Hmm... as with most things, 'depends'. Another consideration would be the nature of the decoded data. If you have a static, fixed, never will change list then you've covered all the considerations. If there is a possibility that it could change, I'd look into storing the decode data in a flat file a...

What kind of help do you need? Seems to me you've got two very similar choices, depending on which you'd feel more comfortable with: 1) Implement something in a BASIC routine. 2) Write a shell script. Both can be called 'after job'. I'd probably got with the latter, but either could be made to work....

The other 'trick' I use when testing custom routines it to leverage the 'Ans' variable. I work through the code in logical sections and return intermediate results as the Answer, that way I can easily see the results when I test from the Manager. If multiple values need to be returned, I pipe delimi...

romkar29 wrote:Even i have tried as follows

/dstage/Ascential/DataStage/DataStage/DSEngine/bin/dssh "SELECT * FROM DS_JOBS WHERE NAME='abcd';"

Even then i am getting the following error
/dstage/Ascential/DataStage/DataStage/DSEngine/bin/dssh: not found

Don't you have one too many 'DataStage's in that path?

I'm sorry... is there a question in there somewhere? Or is this how you managed to get it all working?

Really... no clue it would sync like that. So there's one redeeming quality. I'll have to check it out.

BTW, I made the 'sounds familiar' comment because of this recent post. Give it a read.

Why? Any other way is error prone and unnecessary work, unless you've got a really good reason to delete most of it but not all of it. Just delete the Project if you want to 'clean up whole thing'...

Your friend is correct. Did you need to use User Defined sql or was it just easier to paste the sql in from your query tool of choice? My rule of thumb - User-Defined SQL is only allowed when you have no other choice. And there are very few instances where 'Column Generated' (which has a much longer...

This sounds familiar... delete the project and recreate it.