DSXchange

I don't think screenshots are possible on this forum...so you aren't missing anything...:-) As for your solution I've already tried it. I mean in order to override NLS_LANG at the job level, it has to be defined at the project level as a user defined parameter right? So that's what I've done. At the...

Probably that will work... but the issue is DSENV is for ALL projects on a particular server and I cannot modify DSENV since its only one project which is accessing an Oracle database whereas all others on that server needs UTF8.

SELECT * FROM V$NLS_PARAMETERS; NLS_LANG = [NLS_LANGUAGE]_[NLS_TERRITORY].[NLS_CHARACTERSET] Yes tried that. I use the query: SELECT * from NLS_DATABASE_PARAMETERS WHERE parameter IN ( 'NLS_LANGUAGE', 'NLS_TERRITORY', 'NLS_CHARACTERSET'); I get: PARAMETER VALUE ------------------------------ ------...

Nah Eric. The space is not the problem here. In fact there isn't even a space. the I am overriding the NLS parameter set at the project level using the local parameter $NLS_LANG in my job. What I feel is I need to find a character set which is American but which also accepts UTF-8 characters like th...

Ramesh - That is wicked. Although my problem was sorted (and I marked this topic Resolved) I tried your solution. Its a bit more technical but works. The plus point is I need one .sql file less which makes my deliverable package a little easier.

Thanks

Tony

The -s command helped a lot. Thanks Craig. So to answer your question I was calling the command sqlplus -s in an Execute Command Activity in a sequence job. The SQL command itself is in a .sql file on the server and thus the execute command looks like: sqlplus -s user/password@dsn @file.sql <paramet...

Hello everyone, I have this Oracle SELECT command which calculates the maximum value of a column and adds a 1 to it. I would like to call this in a Datastage Sequence job which I managed to do by first creating a .sql file containing the command. My problem is however in filtering just the result an...

I'm afraid that its intermittent. Another job activity in the SAME sequence job correctly fires the OK trigger based on the Expression Type OK - (Conditional) I would like to however specify something here which I guess i should have earlier, although it shouldn't make a difference: The ob Activity ...

I know in past releases it was order dependent to work - in other words, the Otherwise link had to be last in the order list. Is that true in the problematic sequence? It is last in the order but in this version I can vouch it isn't order dependent anymore. This is because now I am using a workarou...

Well the job log in the Director says: Js_XXX..JobControl (DSWaitForJob): Job Jx_XXX has finished, status = 1 (Finished OK) So for me this falls within the purview of Expression Type is OK - (Conditional) the message (Finished OK) is in the job log. So either this is a bug else when a job finished w...

Hello everybody There's this nagging problem I have had for a while but have managed to find a workaround. I'd like to bounce it by you guys. I have this sequence job which is calling a job activity. I have 2 triggers defined on OK and KO. The link for OK is for when the parallel job in the job acti...

Actually we connect to Datastage through a Citrix server. After some more tests I see that:

Connecting to Citrix from my machine using his account results in the same irritating problem. Thus his Citrix login account is in most probability the culprit.

Anybody else using Citrix?

Hello I have this issue with job compilation. We are all used to seeing a confirmation message when we compile our jobs in Datastage Designer of the kind 'Job successfully compiled with no errors.' with the buttons 'Re-Compile', 'Show Error', 'More', 'Close' and 'Help' to the right. Now one of my co...

Since its a production environment I asked the appropriate team to investigate. They couldn't come up with a plausible explanation but I asked them to reset and restart the job.

Worked like a charm. However next time it is blocked I'll try the grep command.

Good morning / afternoon/ evening to all I have this nagging question that I finally decided to put forth to you all. I have often come across the issue of my Datastage job which remains blocked after the successful execution of one stage for no apparent reason (sometimes for 12 hours or more), at l...