DSXchange

Hi can you tell me where exactly i have to use the command "locale".

and what it will return? how i can change the datastage "locale".

please help me out in this issue.

Hi,

I have already posted the error message..the same message is repeated again...
any other idea... like did anyone knows where the sort settings in UNIX will be..or in datastage..so that i can check which server is having problems...

Hi That solution is also not working...still it is showing having some problem with sorting...

Any other ideas frienz....

I get the error "SQL Datatype of NChar is only supported when NLS is enabled" while compiling. Give me the solution asap.

NLS is enabled in our server butstill it is showing the same error, is it particular to a job or if we have used some language settings..still that problem can come...

please give solution ASAP

I get an error like "SQL Datatype of NChar is only supported when NLS is enabled" while compiling. I need the cause for the error.

Thanks for your suggestions kevin and ray..

I will try this solution on monday and will let u know the status.

frenz, the sort command when it is given in the UNIX consloe it is working fine..but only when it is called from datastage riutine it is giving problems and it iscreating the following error message... Seq_ActsPty_Src_Nb..JobControl (rtSortFileOnKeyFields ???????????): Fatal error when executing the...

Yes the temp diectory is specified and we ddi not make any changes to the default settings... i am sorry frenzzz..... i forgot mention one thing... that is UNIX sort not the datastage sorting stage... we are calling UNIXsortfrom data stage job sequencer.. and it is failing and thats y we are thinkin...

Hi meena,

currently i am not in office...and it is nt showing any particular error..

just giving a message saying " Sorting problem" and the job is getting aborted...

i want to know where in datastage serverwe can find settings for sorting and for other functions...

Hi, I have installed a new datastage server 7.1 version, while running some jobs it is showing an error mesage related to sorting... when we contacted admin they told it is about some settings problem related to sorting. could you guyz plz tell me where to find these settings and getting things corr...

Hi Updates--> InputLink.NOTFOUND <> @TRUE Inserts--> InputLink.NOTFOUND = @TRUE this will not allow in OCI reference stage, even though it shows it wont take the correct records. use IsNull for OCI stage reference. check the constraint value in stage variable and use the stage variable in constraint.

Hi Chulett, Thank you very much for ur suggestion. But the CFF stage can be used for reading purpose only, it wont allow to write into it. "DataTypePicComp3(%CobolString%)" this sdk routine converts Comp3 data type into a numeric value, what we need is reverse process, could you send me a ...

Hi, we are having a migration program where we are getting some data from MAINFRAMES and we have to load it back to MAINFRAMES again. here we have a requirement where we have to convert Comp3 datatype to Numeric and again Convert that numeric value to Comp3 datatype. But in DataStage 7.1 we have opt...

Thanks for your reply,

we need more details about the patch, is it a free one from asecential.com/ibm.com.

if you can provide any support mail id this will helping us,

Thanks in Advance.

any personal quries contact this mail id
dinakaran.s@ctc-tcs.com