DSXchange

Hi, I have a input file and i read the value " 2222.22" as Char(12) and I convert it to Decimal(11,2). By the way, I should validate it as if it has only numbers and no other characters is there like " 33AB.33". If at all any characters found then i should reject the record. how ...

priyadarshikunal wrote:what is the value of APT_STRING_PADCHAR environment variable and what is the data type of the field where you see the junk characters?

Value for the param APT_STRING_PADCHAR = 0x20.

I get the junk characters for all kind of datatypes like varchar, char, smallint.

What you are getting if you use cat filename The control chars are at the end of the line or some where else? How you have configured the Sequential file stage? Whats the delimter you have specified? if i use cat <file name> then i find no control characters. but if i open it in vi <file name> mode...

if i use cat <file name> then i find no control characters. but if i open it in vi <file name> mode then it appears in front of few fields. I create file in Fixedwith mode. also i have tried creating comma seperated delimited file. nothing returns the exact output.

Hi, I have checked in the DB, no control characters found over there. i am viewing the file in Unix, VI editor mode.

Hi, I just extract data from a SQL server table (MS SQL) and write it in a flat file. My job design is ODBC Conn ---> CPY ---> SeqFile I have 50 columns in it. after successful run, I get some control characters in the file like ^C or ^R. Be it Fixed width or Delimited, the file is not getting creat...

Hi,

The ROW_ID column is indexed but I have not used Index HINTS. Is it must for all Upsert jobs?

Hi, I need to perform upsert in a table using User defined SQL. My design is: Dataset----> CPY ----> Oracle Enterprice. For example my update query is: UPDATE Tablename set columnname = ORCHESTRATE.columnname where ROW_ID= ORCHESTRATE.ROW_ID I need to update for some 100000 records. This takes very ...