DSXchange

Hi I have a requirement My input is like this no -------- 1 1 1 0 0 1 0 1 I want output as No new -------------------- 1 1 1 1 1 2 0 0 0 0 1 1 0 0 1 1 If zero comes after one i want the count of how many zeros are coming after 1. if any one knows please help me Thanks&Regards Swathi S

Hi all,

I want to capture all the logs which are there in director to a file.
Is there any possibility to do this.
If any one knows please help me

Thanks

Swathi S

Hi, I want to get a negative value of a decimal field. MY input is 1112223334567822.22 I want output as - 1112223334567822.22 For this i gave output as -1*input but i am getting output as -1112223334567822.24 instead of -1112223334567822.22 When i am using NEG function i am facing same problem Pleas...

Hi all, I am using a sort stage in my parllel job.And i set Create keyChange column to true.I am using this key change column in the constraint of a link which is going to a load in to a particular table. I am getting error as Field keyChange in the input was not found in the db table EDWD2.EDW_JOB_...

Hi,

I want to calculate the last date of the month .
The date i am getting from a sequential file.

data from source:2008-09-05

i want output as 2008-09-30

Can any one please tell me how to implement this in parllel jobs


Thnaks for your help

Regards

Swathi S

Hi ray, Thanks for ur reponse,its working for us.I didnt find any document for limit of using nested convert function,i came to know the limit by modifying the usage of number of nested functions. If i use more than 7 nested functions its giving compilation errors like { ##E TBLD 000000 12:39:54(000...

Hi all, I have to convert char(0) to char(31) to a single space in a particular coulmn. But for using nested convert function like convert(char(0),' ', (convert(char(1),' ', DSLink3.name))) there is a limit to use functions.we can use up to 7 nested funtions. I tried using stage variable also like i...

The first syntax is, essentially, invalid and so will default the third argument (to "B" or "T" - I can't remember which). ... Hi ray , first statement is not invalid its giving the same result as of the second one.but i am not getting the differencebetween those two. Thanks

Hi all,

Can any one please tell me the deifference between below two trim syntaxes

1.Trim(DSLink2.Date,'0','%R%')
2.Trim(DSLink2.Date,'0','R')

I creaeted the sample job to check these two syntaxes but i didnt get the difference in using with and without % syntax.

Thanks

Swathi

No $ sign should be used. Are those "0" or "O" in your parameter name? ... No its "0" in the parameter name. when i used $ symbol before the parameter name i am getting This error Error -3 getting information for parameter '' Status code = -3 DSJE_BADPARAM which is dif...

There is no job parameter named ACT_L00_TRG in the job called jobname. ... i am using that parameter in the job do i need to specifiy $ before the paramater name i.e ./dsjob -run -param $ACT_L00_TRG=/home/singamar/pivot.txt DMSYNC pivot1 and do i need to specify default value for that parameter in ...

Hi, I am trying to run the job using dsjob command and passing parameter for a job form command line i gave this command ./dsjob -run -param ACT_L00_TRG=/home/singamar/pivot.txt project name jobname and i am getting this error Error -3 getting information for parameter 'ACT_L00_TRG' Status code = -3...

Hi,
Can any one give some examples of orchestrate operators available in datastage.

Hi,

can any one help me ,how to create user defined stage .

Thnks
Swathi.

Hi, I am using aggregator stage to perform calculation(max value) on integer field and the field(CONTACT_ID) which is going to store the max value also integer only,but i am getting the error as When binding output interface field "CONTACT_ID" to field "CONTACT_ID": Implicit conv...