DSXchange

Hi Guys, I changed the permission of the script to 777. Now Iam getting warning /data/dev/dataset/soma/test1.ksh: !/bin/ksh/: not found /data/dev/dstage/dataset/soma/test1.ksh: orchadmin: not found ksh test1.sh 6 where 6 is input parameter . Do I need to invoke the shell before it run. Thanks, somar...

Hi, I designed a sequence job using execute command activity and Iam calling the script . In command tab I gave the path of the script and in parameters Iam passing the value but my script is not running when I run the job and it is running fine from command line . Datastage Job is running successfu...

Hi,


when I did orchadmin -help it is saying orchadmin not found




Thanks,
Somaraju

Hi,

I need to create a script to delete datasets that was previously created by jobs. I read in posts that I have to use orchadmin command to do it. Iam trying that command for first time can some body tell what orchadmin command do I need to use to delete the file.



Thanks,
Somaraju.

Hi, Iam using a stage variable "SV" and it has data type varchar 255, in derivation field for SV I have given expression as IF ln1.DIV = '20' then (Trim(ln1.con),4) else SetNull() When Iam compiling a job it is giving an error saying Setting null to this non-nullable field: StageVar0_SV. I...

Hi,

Thanks for the reply I want to use the Discard Value option in Switch stage. I know if you mention the link it will go to that link.



Thanks,
somaraju.

Hi, Iam using switch stage. I have a column Year and it has value starting from 1990 to 1999, in switch case properties I mentioned Case = 1990 =0 Case = 1991 Case =1992=1 Case=1993=1 Case=1994 Case=1995=2 Case=1996=2 Case=1997=2 and in options I mentioned Discard Value =2 MY aim is to discard year ...

Hi,

My problem was solved. In Output tab column (Edit Row ). In Column definition reference the name is not in sink with the column name it has ERR_COL , so it is throwing that error. Now I made the same name as in column name and the job is not throwing any warning.



Thanks,
Somaraju.

Hi, I have 10 input links to funnel stage in my job. When Iam running the job Iam getting an warning saying Warning: Funnel_0: When checking operator: When binding output schema variable "outRec": When binding output interface field "ER_CO" to field "ER_CO": Implicit co...

Thanks folks

Hi,


It is Varchar(10)




Thanks,
Somaraju

Hi, Iam getting three date fields X,Y and Z and there data types is varchar(10) . I want to find the maximum date from X,Y and Z and send to the output. Do I need to convert string to Date and then find Maximum of XYZ or can I do it with out converting . The final output data type to which I should ...

Hi, Iam getting an SIGINT Error while running a job through sequencer but when I run the individual jobs it is working fine. I searched in forum but I am not clear why jobs are aborting when I tried to run the jobs through sequencer . Error : main_program: ORCHESTRATE step execution terminating due ...

Hi,


I have a requirement like this . I need to add a month from input date which Iam getting as varchar (8) . For example 20071201 it must be 20080101 and it must take care of leap years also . Can some body help me in this.


Thanks,
Somaraju.