DSXchange

Hi here is the solution/mistake that i found, Actually while loading data into queue through sequencial file , i was taking all row in same file and loading all rows into queue at a time. But now i am loading each row seperatelly on queue and code is working properly. Thanks for help , i ll be curio...

thanks for reply.

i have tried with ur combinations but its still not giving desired output.

its removing all data from queue.

It was giving the same problem and removing all data from queue after reading only one row. Following are present in MQ stage wait time 2 MessageLimit 1 End Of Data Message 99899 And Destructive Read Commit/BackOut only once at the end of job Do data conversion on the MQGET call These options are cl...

I have tried with non destructive queue , here its only reading first row and not the second one , which is right. Now for destructive queue, with Message Limit as 1 and End of Data Message as 0. I thinks it reads all data from queue (and hence removes all), but only allows first row to proceed. Now...

Hi thanks for reply. but script thing looks out of my reach/access. here is , where i have reached....... In Ascential datastage Websphere MQ stage, properties, Under GENERAL TAB, i have set Message Limit as 1 and End of Data Message as 0. This is Destructive read. Now when more than one row is ther...

Hi here is the scenario, i have a job which will run 2 times a day, which is called in the sequence. This job takes data from message queue and other job process it. Now , I want only first line from queue should be processed whcih every run. If there are two lines of message then 2nd message should...

Hi I have a Message Queue from where I am taking input which is having characters more than 5 lakhs in a single line on queue. But in datastage , in message queue stage , in metadata I can find only LONGVARCHAR (125000) as result when there is single row on queue (say of length 5 lakhs character), I...

I m trying to delete record from tables Dcx_Sub_Dept_Employee and S_Rot_Class. following messges in director , 6 th one is the warning message 1)Del_Dcx_Sub_Dept_Employee..Xfm_Seq_Dcx_Sub_Dept_Employee: DSD.StageRun Active stage starting, tracemode = 0. 2)Del_Dcx_Sub_Dept_Employee..DCX_SUB_DEPT_EMPL...

I am deleting records from table DCX_PLATFORM_TEAM. The job is deleting the desired record also but it gives following warning , plz help how to remove this warning. Del_Dcx_Platform_Team..DCX_PLATFORM_TEAM: alter table DCX_CONSOLIDATED_USAGE drop constraint UK_DCX_CONSOLIDATED_USAGE Del_Dcx_Platfor...

how to use pivot for generating dyanmic number of columns?


e.g.

for i/p

id|d1,d2,d3|status

where d1,d2,d3 is dyanamic (can be d1,d2,d3,d4)

desired o/p

id|d1|status
id|d2|status
id|d3|status




pz help

plaese tell me where extractly internal delimiter is in pivot stage.

i did go through pdf and stage but cant find it

But here number of dept is dynamic and no upper limit is given . So plz tell me if we can pass parameters in pivot stage to do this.

now is there any way , by which i can convert those dynamic part into that number of rows e.g i/p row ID|dept1,dept2,dept3|status o/p ID|dept1|status ID|dept2|status ID|dept3|status e.gi/p row ID|dept1,dept2,dept3.dept4,dept5|status o/p ID|dept1|status ID|dept2|status ID|dept3|status ID|dept4|status...

Please tell how to enable the tracing so as to capture the value that is generating the error

Thanks for reply.

I can modify the input data so as the delimiter within list is different.

So input data will look like this


ID|dept1,dept2,dept3|plat1,plat2|status