DSXchange

Hi All, Recently we migrated from 8.7version to 11.5version of datastage. in 11.5 we could see FTP job getting into hung state, job has only sequential file stage and then FTP enterprise stage with Ascii / FTP transfer mode. Target server is IBMi. This FTP job is a common job and is used by many ins...

Thank You for the Inputs,
will try on this logic mentioned.

Hi Team, I need some help in doing this date comparison logic for the given input and reference file. For the grouping rows on Column1 and Column2, i need to compare the from date and term date in input file with the reference file From date and Term Date. If the input file From date and Term date i...

Hi Team, I am getting the below error message while compiling the job, This is happening only in DEV environment, the same job compiling fine in other enviorments... I tried to delete the job in dev and imported again, still same issue. While debugging, 1. I tried to remove all the stage variables a...

Hi All,

I have changed my windows language setting for Non-Unicode Program to Japan. Now i Am able to view the Japanese characters through datastage View data. Similarly i need to check by updating to China for Chinese Characters.

Its working, not sure this is the right approach.

Thanks,

Senthil

Thanks for the Update. I tried to update my machine language setting(control Panel) to Japanese and Chinese, still the issue persists. But I noted that "Language for NonUnicode Programs" are set as English(United States), Do i need to update this as well to Japan/China? I would request adm...

Hi Team, Currently I am working on the POC to read/Write the Chinese/Japanese data from oracle table into the Target Oracle/Teradata Table and Seq File using the datastage jobs. Source data in oracle looks good and the target data in Oracle/Teradata table also looks good. The Target file while viewi...

Hi All, I am extracting the data from Oracle and loading into Teradata Database. In oracle I have the datatype as decimal(38,10) but in Teradata it is decimal(9,4) only as confirmed by DBA and they recommend to Round off the decimal points in TD. I am using the DecimalfromDecimal with round_inf opti...

I checked the server version under /bin/uv, its Datastage 9.1.0
But my client version is 9.1.2b

Would that create this TD Connector Issue?

Hi Team, I am having the Datastage Client V 9.1.2.b installed on my machine Windows 7. While editing the properties of teradata connector stage, particularly on the Error Table properties, Designer crashes and am not able to edit that. I tried editing the stage from already existing jobs still havin...

Hi Friends, I would like to know how to retrieve the Job Annotation and Job Description using dsjob command. I have around 500 jobs ..I need to validate whether the job annotation and job description is missing in any of the job. I tried with all the commands in Dsjob, but i could not get the above ...

Hi All, I have a parallel job like below using the Basic transformer to call the Routine in derivation. Seq file ------Basic Transformer-------Seq File Inside the Basic transformers derivation am using the Basic routine. While running ,the job aborts with the below issues warnings: library dsjobsh f...

Hi Chullet,

No..Each time it fails at different jobs when rerunning.

Yes, we checked the jobmonapp is running and there is no any warning message such that jobmonapp is not running.

Please suggest...

Thanks,

Senthil Kumar P

Hi Friends, While viewing the job monitor from the Director, for all the stages the status is shown as Unknown and the Num rows is 0. But the job is successfully completed. But the coresponding sequence aborts as it gets the link count from the job which completed with status Unknown. We tried resta...

Hi Team, I am doing simple lookup b/w source and reference using Lookupstage. My source has column as col1 varchar(255) -> value = Product group category My reference has column as abc varchar(20) -> value = Product group cate I am doing a lookup between this two columns and taking some column out f...