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.
Search found 101 matches
- Fri Apr 16, 2010 3:44 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: look up failures
- Replies: 7
- Views: 2351
- 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.
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.
- Thu Apr 08, 2010 8:38 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Datastage Version upgrades
- Replies: 4
- Views: 1735
- 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.
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.
- Mon Mar 22, 2010 7:14 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Datastage error!!
- Replies: 5
- Views: 2456
- 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
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
- 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
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
- 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.
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.
- Wed Jan 20, 2010 10:03 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Datastage strange behaviour
- Replies: 11
- Views: 4872
- Fri Jan 15, 2010 10:53 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Datastage strange behaviour
- Replies: 11
- Views: 4872
- Fri Jan 15, 2010 6:10 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Datastage strange behaviour
- Replies: 11
- Views: 4872
- Fri Jan 15, 2010 5:46 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Datastage strange behaviour
- Replies: 11
- Views: 4872
- 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...
- 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...
- 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