DSXchange

Hi All,
I am trying to find if a raw data type column has a null value. i cannot find any help in the doc or forum.

Thanks

Hi all, I am trying to find if the value of a field which is defined as binary data type as column defination is null or not. I tried doing isnull , isnotnull, length=0 or trim(colname)='' in transformer after the join Stage but none is working. Please let me know if u any idea how to handle null in...

Hi All, I have 3 different links with different column names but all have cust_id as key column and i have to merge them. INPUT: Source link1: Cust_id Col1 Col2 Source link2: Cust_id Col3 Col4 source link3: Cust_id Col5 OUTPUT: Target Link: Cust_id Col1 Col2 Col3 Col4 Col5 Col6 The data can come fro...

Hi all,
I am trying to pad zeros to a varchar column, can i do it using modify stage instead of using transformer stage derivation.

Thanks.

Hey, I am trying to pull data from mainframes to a dataset. I have source then transformer and a dataset in the job design. when i run the job i get the following warnings. Transformer_22,2: APT_Decimal::ErrorBase: From: the source decimal has even precision, but non-zero in the leading nybble, or i...

Hi, I am importing a mainframe file with iway connector and when i try to view the data i get the following import error: #W IIS-DSEE-TFIG-00201 16:26:49(000) <iWay_Source,0> Field "TRANSACTION_TIME" has import error and no default value; data: {* * * * * *}, at offset: 6 >##E IIS-DSEE-IWA...

Hey, Thanks for reply. But the first one ( make_null) doesnt have an input column. @null in server is assigned in transformer when there is no input column present. Which contradictions what u r just said in modify stage make_null(input colum_name). Handle null is used to null the traget value if we...

Hi, Can anyone give example of how to use make_null() (replacing @null in server)and substring(replacing trim in server) in modify stage. I tried using them with following examples but its not working: specification= new column=make_null() specification= new column=substring[0,7](old column) thanks ...

Thanks Arnold and Ray,
I did use [] after posting the topic but it didnt work and coming to other 2 columns, please suggest what is wrong. As i did try converting each columns in a seperate job to see what is wrong but i get the same error message.

Hi, I am trying to do 3 conversions on 3 different columns and i am using Modify Stage. 1) trim to 7 characters on CART 2) trim SITE 3) @null on MIN_PRES. Code: CART:string(7)=substring[0,7] (Mat) SITE=string_trim(Plant) MIN_PRES=make_null() I get the following errors after the run. Error: main_prog...

narasimha wrote:Have you checked the "Automatically handle activities that fail" in the Job properties of the Job Sequence?

Ooops I missed it.

Thanks.

Hi, I Have a Sequencer which is scheduled daily and the sequencer runs few jobs. I'm trying to know if a job fails in a sequence then how can we make the status of the sequence as failed. As generally when a job fails in a seqence the log show the status of the job but still sequencer status is succ...

chulett wrote:Don't declare them, let them 'default'.

I have a job that has only Envir variables as parameters, so i would assume that there should be an empty parameter file for that job.

Thanks.

Hi Guys, I have a job that has Envir variables declared as parameters in project level and i am now running this job from command line by dsjob which accept parameter file name. So if i declare the all parameters in this file with values , how do i utilize the envir variables as parameters. As the p...

chulett wrote:They can be found in the dsapi.h file under $DSHOME/include:

Thanks Craig. It helps.