DSXchange

Hi, I will get input as follows ID|deptlist|platformlist|status Here deptlist will have dyanmic values as dept1|dept2|dept3|... and platformlist will have dyanmic values as plat1|plat2|... Now there are few tables where i want to insert only 1st dept or 1st plat And there are a table for platform wh...

hi, I am getting following error in my job . Its a simple job of extracting data from database and loading it into the sequential file. SrcODDC_PPOPRCH..Src_PPOPRCH: [IBM][CLI Driver][DB2] SQL0450N Routine "SQLTABLES" (specific name "014") has generated a result value, SQLSTATE v...

Hi

we have a unix box where Datastage is installed and its IP is 53.233.7.115


But when I am tried to logging to Datastage client It gives me following error , any idea why it is happing?Plz help

failed to connect to host: 53.233.7.115, project: UV
The connection has timed out (81015)

Hi

I m designing a job where i wann fetch the source data if its got updated after last run of the same job.

hence i m looking for the last run's timestamp, so can i get last's runtime of same job in current run?

plz guide

Hi We have a sequence of which the execution flow as follows, At the first job we are taking out some rows from database and putting into hash file / Seq file. now the if no. of rows = 0 , sequence should be stop executin after this job else sequence should executed I have designed the sequence as b...

for the output that we r getting currently , i/p is one row and o/p is also one row.

In stage i m aggregating all rows.

here is the output what i m getting, <ImportRequest> <SenderReference> <RequestId> FAST </RequestId> <Identity> FAST </Identity> </SenderReference> <CRTData> <BusinessArea> <eid> 1 2 </eid> <name> CG MCG </name> <descriptionEn> CG MCG </descriptionEn> <date_time_updated /> <updateUserLogin> T4950WM ...

thanks for reply

Thanks for ur valueable inputs I m now able to get the file from xml output stage in xml format. nw the desired o/p is as follows , where addr for company is coming from i/p column and each time there ll be only two employes whose names are defaulted. I transformation stage , i m defaulting first va...

thanks for reply. In job I have taken a i/p seq file having data as empname empnumber abc 1 xyz 2 then i have used next stage as xml output stage, followed by a seq file stage. now i have gone through the documentation for xml output stage, and accordingly i was creating a xml meta data (where it wa...

I have a seq input file with two columns. My desired o/p for this job is a xml in a seq file with some additional default data. e.g. input is empname empnumber abc 1 xyz 2 output desired is <?xml version="1.0" encoding="UTF-8" standalone="yes"?> <ImportRequest xsi:noNam...

thanks for reply. SenderReference is parent which will occur only once, and in side CRTData , which is a child BusinessArea can repeat n number of times. For xml we can assume that there will be a higher node on the top of a parent and its childs. The problem i m facing is , even if i send 1 row as ...

I have a MQStage where xml data is getting loaded in Queue. Following Data is getting loaded in queue,(its like parent child data , where parent is 'SenderReference' and child 'CRTData') . There can be more than one child for a parent. <SenderReference><RequestId>CG</RequestId><Identity>CG</Identity...

Thanks for quick reply. I ll like to give u more information on job parameters which are defined for this job. parmeter : AreYouSure default value : Y description : Safety switch - Must be set to Y in order to do anything parmeter :PrototypeJob default value :PROTOTYPEParam description :Parameters a...

hi This is a piece of shell script which is running in Job Control tab in server job. You will find "PrototypeJob" a job parameter in third line of code. The default value for same is "PROTOTYPEParam". i m searching for this file which is having parameter names and their default ...