Search found 25 matches
- Tue Sep 09, 2008 7:37 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Extract and Load from database not using DataStage Server
- Replies: 0
- Views: 1195
Extract and Load from database not using DataStage Server
If you are extracting from a database (any for example Oracle) and loading to another database (again any for example DB2) and not performing any manipulation does the data still go through the DataStage server or can you bypass the DS Server and get the data to be loaded directly from one db to ano...
- Thu Apr 19, 2007 1:20 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle - unable to initialize plug-in (Windows)
- Replies: 2
- Views: 2739
There is no equivalent of dsenv on Windows. You can, of course, set environment variables through the System applet in Control Panel. When you installed DataStage server, did you select the Oracle plug-in stage types? If not, try installing them now using the Package Installer on the server. (In fa...
- Wed Apr 18, 2007 11:46 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle - unable to initialize plug-in (Windows)
- Replies: 2
- Views: 2739
Oracle - unable to initialize plug-in (Windows)
What am I missing? When trying to connect to the Oracle database I get the error "Unable to initialize plug-in". I have tried to search on the forums but all the similar discussions point to unix servers. We are using 2003 and installed version 10 of Oracle server and Oracle client. Config...
- Wed Apr 18, 2007 11:38 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unable to run parallel jobs
- Replies: 8
- Views: 5795
Is it almost finished downloading? Giving access to the group datastage users on the server is done on the tab ' permissions' when you select the properties of the map ' c:\ascential\datastage'. Greetings, Roy Sorry Roy, I just noticed this post. The download took 2 hours and I had to reinstall all...
- Mon Apr 16, 2007 9:02 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unable to run parallel jobs
- Replies: 8
- Views: 5795
- Mon Apr 16, 2007 8:28 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unable to run parallel jobs
- Replies: 8
- Views: 5795
Unable to run parallel jobs
We have just installed version 7.5.2 on Windows 2003 and the server jobs run fine but when running parallel jobs we get the error message: "This jobtype is not currently runnable on this platform". (We have installed the Visual .Net C++ compiler) Could someone point us to the right directi...
- Wed Nov 22, 2006 11:20 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Unable to delete hashed file - job aborts
- Replies: 5
- Views: 3359
Re: Unable to delete hashed file - job aborts
The problem was that the users have been in different groups that have been set up with different permissions. We have created a functional user_id and that was used to schedule the jobs, which then solved the problem.
- Wed Nov 22, 2006 11:17 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unable to populate a char field
- Replies: 12
- Views: 6686
Re: Unable to populate a char field
I could not use insert only (Write only) as there was 1 duplicate row in the data which shouldn't have been there and it was trying to update that row. Once I changed to Insert then update it worked fine.
- Fri Sep 29, 2006 5:35 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Filesize restrictions on filesets
- Replies: 1
- Views: 1683
Filesize restrictions on filesets
I am trying to create a lookup fileset which normally works (average data is 5 million rows) but fails whe trying to create it with an 11 million row source data. It says cannot map table and says there isn't enough space but when we check the space on the server/project there is more than enough fr...
- Fri Sep 15, 2006 1:59 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Viewing filesets
- Replies: 2
- Views: 1902
Viewing filesets
Could someone please tell me how to view data in filesets. I tried the same method as viewing datasets but that doesn't seem to work.
Thanks.
Thanks.
- Thu Jul 27, 2006 3:30 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unable to populate a char field
- Replies: 12
- Views: 6686
- Thu Jul 27, 2006 2:53 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unable to populate a char field
- Replies: 12
- Views: 6686
I have gone into edit Row and there is nothing oyt of the ordinary there. The details are just like every other field in the table I can populate. The table definitions were imported from the database and I haven't changed anything. The column name is Tank_Online_Ind and I have already reimported th...
- Thu Jul 27, 2006 2:01 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unable to populate a char field
- Replies: 12
- Views: 6686
I have tried updating the field directly in the database and that works fine. There is no problem if I use SetNull(), it works fine. The problem is not with not being able to null it, it is not being able to populate it. I thought maybe there is a problem with the data itself but hardcoding a charac...
- Wed Jul 26, 2006 8:30 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unable to populate a char field
- Replies: 12
- Views: 6686
Re: Unable to populate a char field
Ashvin
the only derivation is a Trim. I am not doing any null handling.
I tried changing the nullable setting, it didn't work
the only derivation is a Trim. I am not doing any null handling.
I tried changing the nullable setting, it didn't work
- Wed Jul 26, 2006 7:46 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unable to populate a char field
- Replies: 12
- Views: 6686
Unable to populate a char field
My source data is a Longvarchar and I have to take a substring of that to populate a table in a DB2 database using an ODBC connection. I can populate the table successfully by using the substrings of the Longvarchar but I have a problem with one single field which unless I set to null (using SetNull...