DSXchange

Hello I have a job reading the data from dataset and dumping it into a fixed widht sequential file (Dataset -----fixed width file). All columns in the dataset have been defined as VARCHAR and when i run the job and when i try to view the data out of fixed widht seq file. i was able to view the data ...

In the Modify stage Stage Properties, Define a specification like DLV_ORD_LIN:nullable integer(XX)=In the Modify stage Stage Properties, Define a specification like DLV_ORD_LIN:nullable integer(XX)=int32_from_decimal(DLV_ORD_LIN) and on the output link,specify DLV_ORD_LIN as an integer.. thnaks for ...

i though i have posted in the wrong forum.

thanks

hi i have a problem where i have a column SHP_DT which is a time stamp and i have to handle null and defualt it to a constant value by using modify stage i was trying SHP_DT(outcolumn)=handle_null(SHP_DT, " ") its throwing error saying it is a bad literal can any body throw some light thanks

hi is it possible to handle nulls and conversion from decimal to int on a single column in modify stage. please help me.
i have a case where my column is DLV_ORD_LIN which is a decimal and i have to convert that to int as well as i have to handle nulls together in modify stage.

thankyou
prasad

hi is it possible to handle nulls and conversion from timestamp to string on a single column in modify stage. please help me.
i have a case where my column is SHP_DT which is a time stamp and i have to convert that to string as well as i have to handle nulls together in modify stage.

thankyou

actually i need to count the no of detailed records in the detailed section and and need to use that value in one column of the header section

hello i have a source coming from dataset i need to produce a fixedwidth sequential file which has header and detialed section. i need to capture no of detailed records in one of the columns of header section. i was trying using aggrrgator stage but wasnt able to do.any help would be appreciated Tha...

use 2 column export stages for 2 datasets which you want to concatenate and club them together in funnel stage.that might work...

I have 8 columns in the dataset. col1, col2, col3, col4, col5, col6, col7, col8 I want to have columns in the output h seq file as below. colA = col1 colB= col2 ColC =col3 ColD = sum(col8) group by col1,col2,col3,col4,col5,col6,col7 having col4 =1 ColE= sum(col8) group by col1,col2,col3,col4,col5,co...