DSXchange

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 ...

Were you ever able to wire this up, if so can you explain.


Thanks.
Larry

Mt first question is will the exising infrastructure that is in place remain the same or are you going to charge for the current system.

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 ...

chulett wrote:What "file stages" are you referring to that allow you to suppress fundamental data type mismatch warnings like this?

Format sequential file stage- suppress row truncation warnings!

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...

Any way to turn warnings off from a sort stage into a transform?


Thanks,

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...

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 ...

I was having the same problems last week,

check this post:

viewtopic.php?t=88040

Larry

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...

Thanks for the info.

I am running 7.5 and still getting the square root error message.

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...

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

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...