DSXchange

First read the file as its comes through sequential stage, Then put copy stage and arrange colum as you needed...


BMSK

Hi All, I have input lik this "i have pen and i am ussing for writing books". this should be converted into " I Have Pen and I Am Using for Writing Books". I want to convert into every begin letter into Captial letter except the word like and, for, or, a , is, these should be sma...

Thanks ray

Its solved.

regards
bmsk

Hi My input is like this con_id con_sus_id 1 10 1 8 2 4 3 6 5 7 9 8 My criteriea 1)All Con_id should be indicated as T and con_sus_id would be indcated as C 2) After 1 its should take 10 and then 1 and 8, and 2 and 4 like..... this is the my output reqires COn_id Record_type 1 T 10 C 1 T 8 C 2 T 4 C...

Hi all,

I decleare the environment variable $envtest, when passing the value of $envtest=lastname its working fine.

the same environment varaible when I pass the parameter $envtest= lastname|firstname (with Pipe as delimiter) its not working and throwing error.

regards
bmsk

Hi chulett,

I tried with type, cat as well..but they are also giving the same error..

regards
bmsk

Hi i did the job in the flow J1--> Execute command activity --->J2 I facing the error Call_sequence..JobControl (@EXE_CAT_SQL): Executed: head C:\Satish\sf_query.txt Reply=0 Output from command ====> SELECT A.CONT_ID, B.CONT_ID AS SUSPECT_CONT_ID FROM DB2ADMIN.MDX_DATA_SRC as A,DB2ADMIN.MDX_DATA_SRC...

yes at run time modify stage will perform more than transformer.(execution)

In my first job i will be generated query and store in file. In the second job and in ODBC stage i want to read the query from that file and th pull the data. flow first job seq->transform->seq this is the query i generated SELECT A.CONT_ID, B.CONT_ID AS SUSPECT_CONT_ID FROM DB2ADMIN.MDX_DATA_SRC A,...

Hi all,

I want to pass the query to odbc stage in paralell job, that quey is generated in datastage job its in stored in file from that file i want to pass the genrated query in OODBC stage.

thanks
BMSK.

use Abs() function


regards
BMSK

Hi,

Thank you all,,

when I use the function Getenvironment('$Enttest')

My probelm was solved

thanks nikhilanshuman


BMSK.

Hi all, When i compiled the job i am gettine this error Output from transformer compilation follows: ##I IIS-DSEE-TFCN-00001 18:15:34(000) <main_program> IBM WebSphere DataStage Enterprise Edition 8.0.1.4458 Copyright (c) 2001, 2005-2007 IBM Corporation. All rights reserved ##I IIS-DSEE-TOSH-00002 1...

Hi All,

In Person name Its should contain only character expect apostrophe and hyphen. i want to reject reocrd if speical charcter is there.

thanks in advance
sathish.

Hi,

Just go this link

http://publib.boulder.ibm.com/infocente ... s_811.html

BMSK