DSXchange

Hi,

Thanks a lot. I have implemented the logic given by you. Now it is working fine.

Hi,

My requirement is to display the column name as "DENM_$5_A" in the output .csv file in Datastage. When i give the column name as "DENM_$5_A" in the ouput file metadata i am getting the compilation error.

Can anyone help on this.

Thanks in Advance.

moe information
pTD_SYNC_ID = 1
pTD_SYNC_POLL = 5
pTD_SYNC_TIMEOUT = 1800
pTD_CHECK_TIMEOUT = 0
pTD_END_TIMEOUT = 0
pTD_PROGRESS = 0
pTD_SESSMAX = 8
pTD_SESSMIN = 0
pTD_SLEEP = 0
pTD_TENACITY = 0
pTD_ARRAYSIZE = 10
pTD_RECORDCOUNT = 100
pNUMROWS = 50000000
pTD_ERROR_LIMIT = 0

Hi, my job design is sequential -> transformer -> teradata connector stage. my source file contains 13,00,000 records. it is running more than one hour. Please find the properties which I have given. table action- truncate load- update(multi load) access method- bulk array size- 10 record count -100...

i have given below query inside the teradata connector stage. SELECT MAP_CSE_MSGE_PRTY_BM.PRTY,MAP_CSE_MSGE_PRTY_BM.MSGE_PRTY_C FROM #pGDW_TECH_DB#.MAP_CSE_MSGE_PRTY_BM as MAP_CSE_MSGE_PRTY_BM WHERE CAST('#pRUN_STRM_PROS_D#' as date format 'yyyymmdd') BETWEEN MAP_CSE_MSGE_PRTY_BM.EFFT_D (date, forma...

thanks for your reply.
But I am useing normal lookup

hi, I have used teradata connnector as a lookup. I want to give the below used defined sql query in the SELECT clause. pRUN_STRM_PROS_D=20100101 SELECT PRTY,MSGE_PRTY_C FROM MAP_CSE_MSGE_PRTY_BM WHERE CAST('#pRUN_STRM_PROS_D#' as date format 'yyyymmdd') BETWEEN EFFT_D (date, format 'yyyymmdd') AND E...

Call DSExecute("UV", "CREATE.FILE ":PVFile:" 30",Output,SystemReturnCode) my unserderstanding of above command is 1. This is the UV command. 2.I will create hashed file by useing CREATE.FILE command. I have some queries in the above query. 1. what is the mean by 30? 2.w...

Hi, I xcomed the file from local server to local server. I am useing below command. xcomtcp -c1 -f /cba_app/CBMGDW/DEV/scripts/xcom_bdct_msge.ini REMOTE_FILE=/cba_app/CBMGDW/DEV/inbound/rds/CSE_ONLN_BUS_BM_BDCT_MSGE_20101028.DLY LOCAL_FILE=/cba_app/CBMGDW/DEV/archive/outbound/CSE_ONLN_BUS_BM_BDCT_MS...

Thaks your mail. I changed your code below.Then it is working.

Call DSExecute("UV", "SELECT CATEGORY FMT '32L', NAME FMT '32L' FROM DS_JOBS;',Output,SystemReturnCode) .

Thank you very much

Hi, I have written the server routine which will give the job names and catergery. I am getting the proper output.but alignment is not proper. Please find the code and do needful. EQUATE RoutineName TO 'PersistentValueSae' PVFile="PersistentValueFile" * Open failed. Create the file. Call D...

ray,the elements are not fixed size . Please sugget me

thanks lakner. I want to explain briefly my job design. MQconnecterstage-> xml transfomer(XSLT)-> row splitter (server)-> teradata example : if source is haveing 3 messages after the XSLT we are getting three messages as one line. Because of this I used in row splitter stage (server). it is doing co...

is there any row splitter stage in parallel jobs 8.1 like server?