DSXchange

I dont know from which system data was generated. I got the data in xls over e-mail. When I open the xls, I can view those Chinese character.

Code page used in host conversion program is IBM-1386,code page in Excel is GB 2312.

I dont know from which system data was generated. I got the data in xls over e-mail. When I open the xls, I can view those Chinese character.

Code page used in host conversion program is IBM-1386,code page in Excel is GB 2312.

I am having trouble in viewing file with CJK characters. Please let me know the following : 1. I am able to view the Chinese character in local text editor.In which mode should I FTP the file to DS server (ascii/binary). 2. DS env is NLS enabled. In the DS job, am using Seq file stage to read the fi...

I have a column with longvarchar type that stores data in multiple lines. Please let me know how do I convert that into a single line.

Thanks.

I have the following data as input to XML Output stage. customer division city acme toys boston acme toys new york acme chemical boston acme chemical new york 1st column : /customer/@name 2nd column : /customer/division/text() 3rd column : /customer/city/text() My intention is to get XML output like...

I am facing the following problem. I am getting Chinese data written in English character and I need to apply Chinese address rules on it.However the rule files for China in QS seems to be written in Chinese character.

So, how do I standardize such data.

Actually am trying to convert timestamp to Integer, so am having the following as string : Trim(Oconv(Date(),"D-YMD[4,2,2]"),"-","a") : Trim(Oconv(Time(),"MTS"),":","a") eg 20090521162367 I need to convert it to Integer or Bigint Please adv...

What is the function to convert a STRING type to Integer in server job or in BASUC Transformer.

I need to populate (insert,upsert) some DB2 table.But DB2 API stage doesn't have the option of having Reject links. So, can that be done by ODBC Ent stage. If yes, how.

I can create a job with ODBC Enterprise stage to extract from a database table. However, the job does not work with ODBC Connector stage (with same table & column). Though I can test the connection within it successfully but trying to view the data gives the following error : An exception occure...

My requirement is to create huge No. of Surrogate keys with stat file. Please let me know the job design. Shd it be something like : 1. Surrogate key stage only - create a stat file 2. <Input stage> -> SKG stage -> <Output stage> what will be the option like generate from last SK value. what is the ...

I have in my input fields such as Update Date and Time. I would like to add 6 hrs 30 min to that to get a new date and time. How to do the transformation.
Thanks.

I have used database sequence in the surrogate key stage and able to get its value through NEXTVAL also.It seems the sequenec values are getting advanced but somehow the values are not written into target Seq file stage.

I am using a Surrogate Key generator stage with database sequence (TESTSCHEMA.TESTSEQ). Row Gen -> Surr Key Gen -> Seq file The sequence get exhuasted, but Seq file shows output surrogate key field generated with all 0 values. I dbout the data type is not correct (chosen as BigInt Unsigned). Please ...

I am getting the following error while doing Column analysis.

aborted.manual verify of the px job RT_ABC is needednull

Can not run the column analysis on the whole table, will get the above error for some field or the other.

Please advise.