DSXchange

Hi,

Could you please recheck ur Format Tab, if you have one column for reading the XML File then set only the Record Delimiter, this will read the entrie XML document to be processed by the XML input stage.

Or you could do as what Sud had written.

Regards
M

The Job ran Succesfully once for the yesterdays file. After few hours i recomplied the job and tried running the job again but this time it failed with the same errors. Hi Saurabh As per the above statement, Once the job has run successfully with data why do have to recomplie the job again, Unless u...

Hi Balaji, Thats an option, but I wanted to know how this could be handled in DS Server.

Regards
Mahesh

Hi All,

Could anyone please share their experience of handling EDI file formats?

Currently they have parsers to parse the EDI data to write on to mulitple flat files, Would be great if you'll could share any other way of handling the same.

Many thanks in advance.

With Regards
Mahesh

Hi, If you plan to change your design/stage then If your just doing direct inserts, You could use ORACLE BULK LOADER stage, which will perfom much faster. I had a similiar issue when I tried using the Native Oracle OCI plug in to insert data into the Oracle tables and later I changed to ORACLE BULK ...

Hi All, I have installed Profile Stage, The repository is on DB2 db on an AIX Server,I have tested the same and things are fine, The client needs are as follows: 1. Would like to create a group which has 5 team members UserIDs/PWD so that they can access the PS client individually, In my previous pr...

Hi, If you can check in the DATA STAGE DIRECTOR, then go to Job ---> Cleanup Resources check for the Job name and log out of it else do the following In UNIX got and check if you have any pervious instances hanging, if so kill the instance and then try. Steps to go is as follows: $ ps -ef (will chec...

Hi Vinodanand, Please use the Help provided in Data Stage Client, Pasted what was available from the DS help Stage types. The chosen plug-in definitions are exported. (The Export option does not handle the associated plug-in DLLs. To deploy a plug-in, you must use the Packager Wizard instead.) If yo...

Hi, You have got teh answer in your Question, You need to convert the Date from the Source file into the internal format and use the Iconv function. OCONV(ICONV(Input date,'D-YMD'),'DW') There have been previous posts regarding the same, please check the fourm. Best of luck. :) With Regards Mahesh

Apologies for Posting twice.

Regards
Mahesh

Hi Shilendra, Welcome aboard!!! U could do this in the following way: 1. Use a Sequential file and in this check the option "Stage uses Filter Command", 2. then in the file path pass "/dev/null" 3. pass the filter command "ls -l <directorypath>/*", (Hopefully u have onl...

Hi Shilendra, Welcome aboard!!! U could do this in the following way: 1. Use a Sequential file and in this check the option "Stage uses Filter Command", 2. then in the file path pass "/dev/null" 3. pass the filter command "ls -l <directorypath>/*", (Hopefully u have onl...

Hi, Could you please give some information regarding the load procedure you are following. We use IDoc Load Stage to load data into the SAP environment,Just from your question please do the following: 1. Once you go to the Properties of the IDoc Load Stages you have a tab called "IDoc Type"...

Ai all,

Thank you very much for the explaination.

Apprecaite your quick responses.

With Regards
Mahesh

Hi All, Apologies, This message was a Strange one to me, as I have not come acrossed it :o I am getting this message after I load the IDoc's into the SAP IDoc Stage. - Just to confirm, I actually re complied teh set of Sequencer/Jobs which I need to Execute and re ran the Jobs it worked fine. Incase...