DSXchange

Wow! Thanks for the responses!! Just what I needed.

Thanks again and have a Great Day!!

Greetings - Basic Question: Can someone tell me if there is a relatively easy way to assess the number of DataStage jobs in any given installation? More Info: I am working for a company going through a merger and the time has finally come to make a decision ... DataStage or "the other guy"...

Whoa! Thanks Craig. I totally missed that ...
Arnd - Thank You!! and my apology for missing you on the first Thanks.

Whoa! Thanks Craig. I totally missed that ...
Arnd - Thank You!! and my apology for missing you on the first Thanks.

Thanks Ray!! You got me thinking with those questions - so I went back and took another look at my code. A couple small but significant changes and now it works like a charm!! For anyone watching and hoping for an answer... 1. My code that builds the dynamic table (FunctionB in my earlier post) fill...

Wow - good questions. As far as filling the COMMON Block - I thought that was happening in this part of my code: $INCLUDE DSINCLUDE JOBCONTROL.H COMMON /DSTtable / aDSTTable FunctionName = 'CSTfromGMT' DEFFUN CSTfromGMT(GMTStamp) calling "DSU.CSTfromGMT" DEFFUN DayLightSavingsTime(aDSTTabl...

by the way - would it help to know that I initially wrote this code on version 4 of DataStage? And, to my best recollection, it worked just fine when called from a datastage job.

Hi Ray - hmmm - I hate to admit I'm not 100% sure how to do that ... so here is how I got the data I'm about to post... I went to the project directory/RT_BP759/JOB.1316733923.DT.1493956403.TRANS1 I then counted to "at or about" the 90th line and then extracted that line and several lines ...

Just a note that I'm going to mark this topic "resolved".... At least I now know how to make my non-nls enabled datastage read UTF8 data from Oracle. NLS_LANGUAGE = American_America.UFT8 We never did figure out how to push this data - with valid characters in place of the unreadable ones -...

Just a note that I'm going to mark this topic "resolved".... At least I now know how to make my non-nls enabled datastage read UTF8 data from Oracle. NLS_LANGUAGE = American_America.UFT8 We never did figure out how to push this data - with valid characters in place of the unreadable ones -...

Maybe I'm missing something here - but try changing the "OR"s in your non-reject link to "AND"s. As I read your code right now, if any one of the following is NotNull , that record will go down your non-reject link: Not(IsNull(DSLink2.userid)) Or Not(IsNull(DSLink2.Amount)) Or No...

Thanks for sticking with me Craig! Yep - I"m with you. Here is my current job designs: Job 1 (Source Job): Oracle ---> transform ---> Seq file $NLS_LANG = AMERICAN_AMERICA.UTF8 Job 2 (Load Job): Seq file ---> transform ---> SQL Server $NLS_LANG needs to be UCS-2 I understand that UCS-2 is a &qu...

I think I'll go with the if you don't have any issues, don't worry about setting it idea...but thanks. Now - here's a continuation of my dilemma. I am sourcing my data from Oracle - which is also set to UTF-8 - so the sourcing is working much better now - thank you. HOWEVER, my target is a table in ...

I think I'll go with the if you don't have any issues, don't worry about setting it idea...but thanks. Now - here's a continuation of my dilemma. I am sourcing my data from Oracle - which is also set to UTF-8 - so the sourcing is working much better now - thank you. HOWEVER, my target is a table in ...

Thanks Again Craig! I replaced "UTF8" with "AMERICAN_AMERICA.UTF8" and that appears to have done the trick. For the record - what is LC_CTYPE? And do I need to set this in the administrator as a user defined env variable? If yes, then do I set the default value (in admin) to &quo...