Search found 90 matches

by theverma
Mon Oct 16, 2006 8:14 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Link Opening Error
Replies: 15
Views: 6820

I tried this but it donot works....
by theverma
Mon Oct 16, 2006 7:49 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Link Opening Error
Replies: 15
Views: 6820

LinesWithoutHeader is the link name.. for which it is giving me error
by theverma
Mon Oct 16, 2006 7:43 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Link Opening Error
Replies: 15
Views: 6820

No it shud show other rows also.....
ANd LinesWithoutHeader is the link name..
by theverma
Mon Oct 16, 2006 7:37 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Link Opening Error
Replies: 15
Views: 6820

It show me one row of data.
by theverma
Mon Oct 16, 2006 7:27 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Link Opening Error
Replies: 15
Views: 6820

I m uploading DB2 Table using DB2 Stage.
Yes it is giving me error at the first row.

Thanx
by theverma
Mon Oct 16, 2006 6:37 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Link Opening Error
Replies: 15
Views: 6820

Hi,
This is an Output link and i m inserting values into a table.I have added this link now.
Earlier the job was working fine.
There is sequential file at the input end of the transformer.
If any further information is required,please get back to me.

Thanx
Arun
by theverma
Mon Oct 16, 2006 5:54 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Link Opening Error
Replies: 15
Views: 6820

Link Opening Error

Hello friends.... I m facing a problem of error in link opening on one of the link in Job. After two warnings the job give a fatal error and stops. The seqence of warnings and fatal error in the Log file is shown below : Warning : PS_PP_JRNL_LN..PS_MB_JRNL_HDR_MIS: Error occurred during link open pr...
by theverma
Tue Oct 03, 2006 5:08 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Enhance performance
Replies: 4
Views: 1200

OK...

But i m using IPC's...so do i need to remove these extra stages from the job or will their presence donot effect the performance of the job.
by theverma
Tue Oct 03, 2006 3:51 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Enhance performance
Replies: 4
Views: 1200

Enhance performance

Hello Friends... I m importing a sequential file and the data has to be validated against some setup tables before inserted into the target tables. I m using Interprocess stage in b/w the sequential input file and the first transformer and then at the output before the DB2 Stage. Please post ur sugg...
by theverma
Tue Oct 03, 2006 3:35 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error in opening a job
Replies: 7
Views: 1569

Thanx friends...
This as been done..!!!
by theverma
Mon Oct 02, 2006 12:10 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error in opening a job
Replies: 7
Views: 1569

Thanx for the reply..but my Cleanup Resources option is coming disabled in the Director > Job .
Only i m the owner of the Job.

Thanx
by theverma
Mon Oct 02, 2006 11:24 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error in opening a job
Replies: 7
Views: 1569

Error in opening a job

Hi Friends...
I have ended my job forcefully by doing the end process from the Task Manager.But now it's not opening and giving an error message like 'it is being accessed by another user'.
Any help will be highly regarded...
Thanx
by theverma
Wed Jul 19, 2006 10:00 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to Transform 09302006 to a valid date
Replies: 16
Views: 3841

the above code is not working....
i have '09312006' (Char) as the input and i want this to insert into the database...
i m using SQL Server Database.
Thanx
by theverma
Wed Jul 19, 2006 9:27 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to Transform 09302006 to a valid date
Replies: 16
Views: 3841

How to Transform 09302006 to a valid date

Hi everyone..
Can you tell me how to convert a string of length 8 to a valid date so that i can insert it into the database.
Thanx
by theverma
Tue Jul 18, 2006 10:49 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Not Able to fetch values from a Hashed File
Replies: 2
Views: 758

Not Able to fetch values from a Hashed File

Hi DSExperts,I Load one hash file with 4 rows but when i use that hash file in another job as an input to the Transformer stage,I m not able to retrive the rows of data.I am using hash file to get some additional field values in the job.