Search found 101 matches

by arnie_nits
Fri Apr 16, 2010 3:44 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: look up failures
Replies: 7
Views: 2351

2 keys columns...
customerid and country
customerid=3*3BARS*COKS
country=USA


I tried with only customerid ,even then it was failing.

I also tried with ereplace(customerid,'*',''),even that failed.

Regards,
Arnie.
by arnie_nits
Fri Apr 16, 2010 3:16 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: look up failures
Replies: 7
Views: 2351

look up failures

Hi,

I am getting a very strange problem. All my source records are failing lookups. But when I try to fine the records in the lookup hash files they are present.
What might be the reason. Please help.

Regards,
Arnab.
by arnie_nits
Thu Apr 08, 2010 8:38 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage Version upgrades
Replies: 4
Views: 1735

thanks for the reply....

So can we install ds 8 client in Vista and can work with 7.5 in Server?

Regards,
Arnab.
by arnie_nits
Thu Apr 08, 2010 8:24 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage Version upgrades
Replies: 4
Views: 1735

Datastage Version upgrades

Hi,

Currently we are using datastage 7.5 (client) in windows 2000. Later at some point os will be changed to Vista.

1.Can 7.5 be used in Vista Machine?

2.Is it necessary that the client and serve versions be same.


Regards,
Arnab.
by arnie_nits
Mon Mar 22, 2010 7:14 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage error!!
Replies: 5
Views: 2456

Yes.....I am unable to create copy of any job.

I guess this space issue.
I also got an error like:
ds_seqput: error in 'write()' - No space left on device.

Regards,
Arnab.
by arnie_nits
Mon Mar 22, 2010 6:58 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage error!!
Replies: 5
Views: 2456

Datastage error!!

Hi ,

I am unable to create copy of jobs.

Here is the error:

Error creating job CopyofABC to copy into
Error while creating job CopyofABC
Cannot open file RT_CONFIG10818

Please suggest.

Regards,
Arnie
by arnie_nits
Mon Mar 22, 2010 12:02 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Insert in table with columnname "PRIMARY"
Replies: 1
Views: 985

Insert in table with columnname "PRIMARY"

Hi,

In one of the tables (db-SQL SERVER) a field name is PRIMARY,which is also a keyword.

While I run the insert job, it throws error like:

[ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'PRIMARY'

Please suggest.

regards,
Arnie
by arnie_nits
Mon Mar 08, 2010 12:34 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem with DSN creation
Replies: 4
Views: 3216

Problem with DSN creation

Hi,

I am trying to create a DSN . I have made an entry in .odbc.ini file.

But thats not working. Is anything else needed to be done?

regards,
Arnie.
by arnie_nits
Wed Jan 20, 2010 10:03 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage strange behaviour
Replies: 11
Views: 4872

I tried a lot by re-installing many times.

Someone please suggest. Hasn't anyone faced this problem before?


Thanks and regards,
Arnie.
by arnie_nits
Fri Jan 15, 2010 10:53 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage strange behaviour
Replies: 11
Views: 4872

Well no Java..but do have .Net installed. Is that the problem??

Regards,
Arnie
by arnie_nits
Fri Jan 15, 2010 6:10 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage strange behaviour
Replies: 11
Views: 4872

I have re-installed DS twice now. Still the same problem.

Regards,
Arnie
by arnie_nits
Fri Jan 15, 2010 5:46 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage strange behaviour
Replies: 11
Views: 4872

I have re-installed DS twice now. Still the same problem.

Regards,
Arnie
by arnie_nits
Fri Jan 15, 2010 3:36 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage strange behaviour
Replies: 11
Views: 4872

1. No I restart the system often. 2. No . From another system I was able to open the source stages of same jobs. 3. No network issue. 4. I checked that. With no programs open I was getting the issue. Also I re-installed DS. Still the same problem. I use DRS staged in server and there I get the probl...
by arnie_nits
Fri Jan 15, 2010 3:18 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage strange behaviour
Replies: 11
Views: 4872

Datastage strange behaviour

Hi, I am facing a strange problem. The source stages doesnot open. When I double click on the databasestages the nothing happens. And then when I close the job,it ask "Do you want to save". Then when I close Datastage I get an error like: The instruction at "0x6c3ebd5c" reference...
by arnie_nits
Tue Nov 17, 2009 1:15 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Computed blink of 0x830 does not match expected blink
Replies: 7
Views: 10663

Thanks...

Well I took a copy and ran that....it ran successfuly.

Regards,
Arnie.