Search found 69 matches
- Wed Mar 29, 2006 1:21 pm
- Forum: Data Integration
- Topic: DataStage versus SQL Server Information Services
- Replies: 11
- Views: 36722
Datastage vs. SSIS - IMHO
I like to chime in on this since I believe that the cost savings is not only the ETL tools SSIS vs Datastage. If you have SSIS you now have an enterprise level database that supports partitioned tables as well as mirroring (SQL SERVER). You can save the expense on Oracle and it's licenses which are ...
- Mon Apr 18, 2005 1:39 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DataStage Working with Postgres
- Replies: 1
- Views: 1880
Re: DataStage Working with Postgres
Were you ever able to wire this up, if so can you explain.
Thanks.
Larry
Thanks.
Larry
- Thu Dec 16, 2004 12:52 pm
- Forum: Site/Forum
- Topic: Premium Services on the DSXchange
- Replies: 16
- Views: 15524
- Fri Oct 29, 2004 6:18 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Bugs for Version 7.x
- Replies: 7
- Views: 4010
Not fixed in version 7.5 Yet
Topic: INT() function returning incorrect values Product: DataStage Release: 7.0 Date Entered: 06/16/2004 Fixed in Release: 7.1r2 Date Closed: Full Description: The INT(arg) function returns the previous value of the INT function if arg is NULL. eg INT(1234.50) = 1234 INT(@NULL) = 1234 When INT has ...
- Mon Oct 04, 2004 8:00 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Sort stage Warnings
- Replies: 6
- Views: 4055
- Mon Oct 04, 2004 7:39 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Sort stage Warnings
- Replies: 6
- Views: 4055
Just peachy!
Only way to "turn them off" is to ensure they don't occur. Looks like you have an "empty" field that is being moved into a Long datatype and it doesn't like that. Can you check for and transform that to something else before the Sort stage, like to a NULL or a Zero perhaps? If t...
- Mon Oct 04, 2004 6:49 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Sort stage Warnings
- Replies: 6
- Views: 4055
Sort stage Warnings
Any way to turn warnings off from a sort stage into a transform?
Thanks,
Code: Select all
Sort_10: At row 1, link "DSLink24", while processing column "FUBAR"
Value treated as NULL
Attempt to convert String value "" to Long type unsuccessful
Thanks,
- Mon Oct 04, 2004 5:22 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Sql Server & ODBC LInked Server Column definitions
- Replies: 2
- Views: 2619
Re: Sql Server & ODBC LInked Server Column definitions
Why not create a view on the SQL Server database that does the query to the linked table. Once you have imported the metadata you can drop the view and use the fully qualified (4 part name) in the ODBC generated SQL. Better yet leave the view and use it for the ETL. If I was allowed to create it my...
- Fri Oct 01, 2004 1:36 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Sql Server & ODBC LInked Server Column definitions
- Replies: 2
- Views: 2619
Sql Server & ODBC LInked Server Column definitions
I want to import a linked server to microsoft access files table definition. I think i need to pass a query to get the info I desire since the linked server is not accessed through a database. This doesn't seem to be an option through import odbc. select * from access_data...tbldebatequestions. Any ...
- Mon Aug 09, 2004 12:35 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Handling XML document as INPUT FILE
- Replies: 5
- Views: 3891
- Fri Aug 06, 2004 11:33 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: XML repeating nodes
- Replies: 11
- Views: 7867
What is the best way ...
Can you go from an XMLINPUT file throught a regular transform to a sequential file. What I want to do is 1) read an XML file 2)write the data to a sequential file with different coulmn attributes. So I want to move the data in a xml file to a flat file. Does it have to go to a odbc or database stage...
- Fri Aug 06, 2004 10:11 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: XML repeating nodes
- Replies: 11
- Views: 7867
- Fri Aug 06, 2004 8:48 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: XML repeating nodes
- Replies: 11
- Views: 7867
Hi, I am trying to create a simple example using xml as input. I am struggling through the documentation and can't find version 2 examples anywhere. I have a folder input pointing at an xml file with a link going to an xml input stage and then to a sequential file, I don't even know if this is legal...
- Thu Aug 05, 2004 6:19 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Sql server 2000 connection error - Initial setup using odbc
- Replies: 6
- Views: 5128
Ipconfig is your buddy
Your probably right the IP is 192.168.
I referred this problem to the Admin.
I'll let you when I get a resolution.
Thanks,
Larry
I referred this problem to the Admin.
I'll let you when I get a resolution.
Thanks,
Larry
- Wed Aug 04, 2004 10:11 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Sql server 2000 connection error - Initial setup using odbc
- Replies: 6
- Views: 5128
Sql server 2000 connection error - Initial setup using odbc
The following is the error message I am receiving. DSR.MetaGeta(GET.TABLES)(SQLConnect('SQLServer','sa')): BCI Error: SQLSTATE=08001,CODE=11,[DataStage][SQL Client][ODBC][DataDirect][ODBC SQL Server Driver][libssclient19]General network error. Check your network documentation. SQLSTATE=01000,CODE=14...