DSXchange

Hello Pankaj Check the number of CPUs you have license for in your administrator and cross check that number with your default apt file. If you have a sequential file that you are reading your data from please double check the delimiter that you specified and the length of each column after comparin...

chulett wrote: .....can't Compile them from Manager.......

thought it never went beyond that point....

sorry it was my fault never realized that it was server....My fault.

Tracy If you are very confident that both servers have the same config, same versions, same patches etc... let me ask you one last thing before someone else familiar with a similar issue helps us understand this better. if you say that you test/dev box still has the unchanged code .... can you pleas...

Tracy
Hello again

do you find that all these jobs that have started showing issues have any similarity? do you think they all use those routines that you re-promoted?

Hello Tracy how were your jobs run untill these issues started to surface. where they scheduled in production?? where they being run from director?? how often is your code compiled. again are they just compiled or force compiled?? when was the last time any code was promoted into the prod box? what ...

HI what is your NLS characterset?? 1. is your source coming from a file or a database 2. if file, how is it created. how does it look on unix? if database when queried how does it look outside datastage? 3. if your source is a database and if you think its datastage thats changing it...are u using a...

Hello

If you can afford to use a parameter and call the job from a sequencer...
you can pass in
Convert('-: ','', DSJobStartTimestamp)
it would create your file as 20090218135610.csv

cheers

Shashank

Do you have any special characters in your passwords? can you view data on that stage??

this topic has been discussed several times... you might wanna try searching on "dboption" and find a suitable scenario that suits you.

cheers

Shashank

Do you have any special characters in your passwords? can you view data on that stage??

this topic has been discussed several times... you might wanna try searching on "dboption" and find a suitable scenario that you are in.

cheers

ravireddy25 wrote: 2008-10-20k

Ravi

what is that K for??
did you try looking through your source data to figure out any abnormality?
does it look fine there.
if your row count on the source is lesser than 9999 are you able to view data on the source file through datastage?

cheers
VM

Manish

what does your job do?? how many nodes are you running your job on??
would your job work fine when you run it sequentially??

cheers
VM

what do you mean by incorrect results.... can you please quote an example...

hi everyone the fact that no one has replied was suprising indeed but. :? i raised an issue with IBM on this and they said that in a parallel job even using a API stage we cannot have the feature of using like in the user defined sql in the lookup table which u can achieve in a server canvas. this i...

hello DS Gurus we have just a month back started moving from oracle to teradata. now the problem is that ... i have to do a lookup on a reference table in terdata. im using teradata API stage my input master link has called_numbers that are like 0044795674689 0044324793434320 00123784504 00884950434...

Guys ... thanks for your support....i am going to raise a call with IBM on this and hopefully that is a bug which we can find a patch for.... for now i am using the sequencer. would post the response once IBM suggests me an answer for it so that it would be helpful for others. untill then...thanks a...