DSXchange

you can pass the different value as parameter. if you are triggering the sequencer from unix script.

Is UTF 8 characte set is enabled at job level?
Try to remove the ustring (entended property of meta data).

Hi Experts,

Any help will be appreciated.

Date format not matching when null is coming in date fied for the fixed width file, which is reading entire string as single fiels. sample warning: tfpDateProcess,0: Data string ' ' does not match format '%yyyy%mm%dd': an integer was expected to match tag %yyyy. tfpDateProcess,0: Conversion error ca...

If you have the access . follow the below steps from unix. Step1:log to ds engine /opt/Ascential/DataStage/DSEngine Step2: Type the following three commands one after the other $DSHOME . ./dsenv bin/dssh step3:ogto ur project Step4: In the command prompt, type the following command LOGTO UV Step5: T...

In version 8.x through webconsole,we can unlock the job.

let us know the arraysize value?

If inlnk.inputfield < 0 Then '-':right(Field(inlnk.inputfield ,'.',1,1),8) Else right(Field(inlnk.inputfield ,'.',1,1),8) [/quote] My target column is varchar. Do i have to do decimal to string conversion or is not needed?[/quote] Before using the inlnk.inputfield in derivation convert it to decima...

leonardo2 wrote:Can anybody tell me how to read a excel file from datastage

Conver the Excel sheet to .csv file and use sequential file stage to read the same.

I am using the following: if col<0 then "-":right(abs(col),7) else right(abs(col),7) please suggest me the correct way to do this.[/quote] you can try this code: If inlnk.inputfield < 0 Then '-':right(Field(inlnk.inputfield ,'.',1,1),8) Else right(Field(inlnk.inputfield ,'.',1,1),8)

Hi, Iam having trouble converting the null values to not null. Can you please guide how to convert the nullable values to not null using the transformer stage or any db2 query ( i used nvl and coalescequery it is not working ) Iam getting the values from the database which are having null values an...

kris007 wrote:Have you tried User defined SQL?

As kris007 suggested user defined delete statement will work in ODBC stage to delete records.

Please help me, to get the jobs list from subcategory through command line.
Suppose if we have jobs-->DE ACCT-->Subcategory.Now we need the list of jobs from Subcategory folder.

In your case, please put an output stage after your source stage that just writes this one column into a flat file, then use "od -x" to see if the spaces are actually present or if there is now a tab in the string. If the spaces remain then you have discovered a problem in "view data...

I didn't even know that categories can be created with embedded spaces. When you execute the command with quotes, what is the dssearch output? Thanks ArndW for the reply. we can create the categories with spaces in between . We tested with giving quotes its working fine now.previously we ran in dif...