DSXchange

Hi, I have more than one repetition elements in my xml file. So when I select more than one column as key in the output tab of xml input stage, I get an error saying more than one repetition rule specified. How do i handle when there are more than one repetition elements present in the xml file. Tha...

Hi, I have more than one repetition elements in my xml file. So when I select more than one cloumn as key in the output tab of xml input stage, I get an error sayint more than one repitition rule specified. How do i handle when there are more than one repetition elements present in the xml file. Tha...

I meant I have tried each of those 2 stages in 2 different jobs.

Hi, I was trying to read an xml file using sequential file stage and External source stage in a parallel job. I get some errors. I was able to read teh file succesfully in server jobs using folder stage. Can anyone please help me? I get the following error when I use this string "ls #C:\Datafil...

Hi,

Good morning.I am getting Oracle broken pipe error while I am transfering data from Oracle partioned table to Oracle non partitioned table by using Oracle eneterprise stage in Data Stage 8.0.

Colud you please help me on this issue.I appreicate your help and time.

Regards
Narasa

Hi,

We would like to populate Jobrunid unique number for all records during the job run.
like for first run it has to populated with 001,second run 002 like that.

Could you please help me on how to get the unique data for all records.

I appreciate your help and time.

Regards
Narasa

Hi Guys,

We are planning to migrate from 7.5.1A server edition to 8.0 parallel edition.Could you please tell me when can I get training from the dsxchange group in DC area.

I look forward from you guys.

Regards
Narasa

Good morning guys, I am transfering data from ODBC stage to Oracle stage both source and target columns are varchar2 datatype.In one of the column I am getting trailing spaces.i used trim function to remove those spaces butit didn't work.I am thinking those are not spaces may be tab or some other ch...

Thanks for response. I have administartive rights but when I used SELECT COUNT(*) FROM DS_JOBS WHERE NAME NOT LIKE '\\%'; it is showing only one count.It supposed to have 500 jobs. When I ran REINDEX on DS_JOBS it is showing following messages. * Re-indexing DataStage Repository file: DS_JOBS File &...

Thanks for quick response.

I followed the following steps but I couldn't recover jobs.

DIVERT.OUT ON &UFD& reindex.log
DS.REINDEX ALL
DIVERT.OUT OFF

Can you please help me on this.

Regards
Narasa

Hi,

Good evening.All jobs are deleted suddenly in one of my project but other projects having jobs.Could you please help me on what happened exactly.
Is some one deleted or some datastage issue.
I appreciate your help and time.

Regards
Narasa

Sir,

We have Windows server so i created user and assigned admin rights to the new user.Every thing is working fine.But we have 3 projects on that server.How can i give access to only a particular project?

Can you please help me on this issue.

I appreciate your help.

Reddy

Hi Guys, Daylight savings time will now start on March 11, 2007 (rather than early April) and will end on November 4, 2007 (rather than late October)". We are going to install patch on Windows server where Datastage installed. Do we have any Datastage patch for this day light saving. Any ideas....

Hello Sir, My business scenario like this : 1.I need to run job1 and job2 daily using batch1 except on 4th business day of every month. 2.I need to run job1 and jobx and joby 4th business day of every month using batch2. How can i design the batch and scheduling using datastage. note: i will get the...

Thanks alot for valuable suggestions.

I am scheduling the jobs using Datastage Director.

Thanks
Reddy