DSXchange

in your xml output for columns give xpath like this, Hi <IDOC>/<PROD_HEADER>/@value <IDOC>/<PROD>/@value <IDOC>/<DETAIL>/@value <IDOC>/<PROD2>/@value <IDOC>/<DETAIL2>/@value <IDOC>/<PROD3>/@value <IDOC>/<DETAIL3>/@value once output.xml file is generated , you can call the same .xml file using seuent...

Frens, m using MS access database has source and writing in to a .txt file, I have problem in writting the arabic character in target file, In Source, i have used nls job default has MS1256 and checked column per mapping and selected NLS as ISO8859-6 but still i couldnot able to get the arabic chara...

chulett wrote:No.

IConv. Subtract. Done. ...

thanks Craig

You subtract the internal values to get the number of days between, so ditch the OConv otherwise you're just 'subtracting' two strings. ... is there any other way to do this? if so please let me know... i have stored those two columns in other file by converting it to date and i used those columns ...

frens, source is .txt file i have two columns , column1 has data -20170331 (yyyymmdd) column2 has data -31052008 (ddmmyyyy) my requirement is to calculate remaining days by subtracting column1-column2 to get it done i have coverted those column valeus to date and i have subtracted it , and my output...

Thanks alot frens

Frens, I have installed Datastage 7.1 , Server installation in d drive and client installation in c drive When i tried to run the job (in which am using the oci stages ) its throwing the error as ds_loadlibrary: Win32 error in LoadLibrary of oraoci9.dll - Access is denied. Please let me know hoe to ...

will try to do that..

Thanks a lot to everyone.

chulett wrote:Sounds like you need the Windows XP "Service Pack 2" patch for DataStage. Request it from your support provider. ...

i cannot able to see any properties of any stages which i use in job sequencers, in my datatstage designer- server jobs i can see all my stage properties, yes some executable has to be runned to enable the properties window from the installation folder of ascential datastage..but i forgot the name a...

Yes only when i try to open job activity properties in job sequencer i couldn open it.. other than jobsequncers everything is working fine.. i guess some exc has to be runned... When you say 'job activities', are you talking about sequence? Did you try closing the Desginer session and starting a new...

Frens, i have one small issue, i have just draged and dropped all job activities wen i try to see its properties,i couldn able to see it..when i double click on it its not opneing.. can u please tell me if there any patch or exe has to be runned ? if so pls let me know the path and the name to be ex...

Reporting Assistant was deprecated at version 5.2, and does not handle job sequences. ... Thanks , i can easily identify the sequence of jobs run in job cotrol..as it is considered as job and it has been updated in reporting database...even i can easily identify the dependencies of the jobs.. is th...

Hi I have a question in joining the records in a sequential file and a table. Can we directly join/lookup a sequential file and a table (using transformer) or should we have an hash file in between..i have seen this in many jobs that a hashed file is used before joining..but is that mandatory? its ...

Hi All I have a scenario here Input : Col 1, Col 2, Col 3 ============= 1, abc, 123 1, abc, 123 1, abc, 456 2, def, 111 2, def, 112 Output : Col 1, Col 2, Col 3 ============= 1, abc, 1 1, abc, 2 1, abc, 3 2, def, 1 2, def, 2 Can please suggest how can I do this using stage variables ? my source and...

Reporting Assistant was deprecated at version 5.2, and does not handle job sequences. ... Thanks , i can easily identify the sequence of jobs run in job cotrol..as it is considered as job and it has been updated in reporting database...even i can easily identify the dependencies of the jobs.. is th...