DSXchange

Hi All, After some trial and error I finally managed to achieve what I needed by putting this code into Generic stage: transform -expression ' outputname 0 outRec; mainloop { outRec.NEW_ID=u_trim_leading_trailing(col1)+u_trim_leading_trailing(col2); writerecord 0; } ' -inputschema record(col1:ustrin...

Hi Ray, I did try with semicolons. Code below is one of examples of generated OSH of the generic stage with semicolon: ################################################################# #### STAGE: Generic_270 ## Operator transform -expression 'NEW_ID=u_trim_leading_trailing(B40OPU)+u_trim_leading_tr...

Hi All, Can anyone give a simple working example of using a "transform" operator in a "generic" stage. I am trying to achieve a simple thing - to trim and concatenate two or more columns, but these columns' names are known only during runtime. example inputs: col1: 'aa ' col2: ' ...

So I managed to solve the task in a different way. I used a simple sequential file reader stage but with 2 modifications: 1. Manual Filter setting - I added a gunzip command there so I can read directly from a .gz file gunzip -cfq 2. Manual Schema File option - I was not aware that something like th...

Yes, all our Char/Varchar columns have Unicode property set.
Does it influence the standard project setting and somehow forces the usage of UTF-16?

What do I do if NLS is already set to UTF-8 in DS Administrator and the same error still appears?
The job itself uses UTF-8 only, I cannot find any other place where UTF-16 could be specified...

Hi All, I have designed a very simple parallel job which reads a file and uploads it to a TD table. read_file (Generic) ----> TD_Stage (TeradataConnectorPX) I use Generic stage to be able to replace the columns definition during the runtime with a given parameter. Then RCP is used. Everything works ...