DSXchange

After a bit of hacking, I've deduced that TO_DATE must be an internal DataStage function that converts the string to the proper format for the target database. TO_DATE isn't a SQL Server function, although I've used it before on Oracle projects. No, TO_DATE() is not anything internal to DataStage, ...

Which means that even though you're using the DRS stage, you are probably still talking to SQL Server through an ODBC interface. That depends entirely on the 'Database type' setting, it supports both ODBC and MSSQL Server. The OP hasn't specified which they are using. DRS Stage with MSSQL Server da...

Just a curiousity question: is this the same in DS 8.x? IMO, if it doesn't allow me to drag the upstream key reference, but allows me to type it in, but it still stays red, but in fact works, then it's a design bug. It may work as designed, but the design is crap :? However I do understand that ther...

The Sequential File stage can not read spaces that aren't there in the data. Simply specifying Char(6) in the metadata does not magically make it so. Hi Ray, Thanks for the reply. I'm not wanting DS to "magically make it so." However, I was hoping it would honour the datatype and length s...

Hmmm, how to simplify my problem description??? Say I've got incoming data like so (NK=natural key, SK=surrogate key): NK1, NK2, NK3 And hashed files used for lookups (reference links) like so: NK1 --> SK1 NK2 --> SK2 And a composite key in my final lookup: NK3, SK1, SK2 IOW, my incoming file contai...

Hi, I'm trying to read an XML file and output to a SQL Server table. I've reviewed this tutorial: http://www.ibm.com/developerworks/data/library/techarticle/dm-0703xiong/#partII However, when I tick "Include namespace declaration" and click "Load...", it appears to parse the XML ...

Unfortunately we only have DS Server 7.x, so I'll get busy creating my 30 jobs. Thanks for the reply...

Hi, Say I have 3 tables (more like 30): Table Foo ColA_Key ColB_Var Table Bar ColC_Key ColD_Var1 ColE_Var2 Table Blah ColF_Key ColG_Var Say I create a CSV file (or database table) like so: TableName,KeyVars,DataVars Foo,ColA_Key,ColB_Var Bar,ColC_Kay,ColD_Var1|ColE_Var2 Blah,ColF_Key,ColG_Var I'd li...

Say you have a sequential file as follows: Col1 << name of column ABC DEF GHI The column is specified as char(6) in the columns tab Say you have a database table "Lookup" as follows: Col1 <<< name of column ABC GHI JKL The column is specified as char(6) in the columns tab My job is using t...

why a syntactically correct SQL Server insert statement fails in DS Working with SQL Server from UNIX utilizes ODBC, so I'd look at the capabilities/limitations inherent in the ODBC driver for SQL Server. Mike Does it matter that I'm using the DRS stage and not the ODBC stage for output? I thought ...

why a syntactically correct SQL Server insert statement fails in DS Working with SQL Server from UNIX utilizes ODBC, so I'd look at the capabilities/limitations inherent in the ODBC driver for SQL Server. Mike Does it matter that I'm using the DRS stage and not the ODBC stage for output? I thought ...

What I'm wanting to know is: 1) Why doesn't the DRS stage create TO_DATE(?,'YYYY-MM-DD') code if the output column type is DATE? 2) If INSERT INTO dbo.ScottDateTesting (EffectiveDate) VALUES ('2009-25-02') works in SQL Server, then why doesn't INSERT INTO dbo.ScottDateTesting (EffectiveDate) VALUES...

(1) Have you tried using an internal format date? (2) Have you tried using an internal format date with the Data Element set to Date? ... (1) You mean something like iconv("2009-02-25","DYMD") == 15032? Nope. If SQL Server accepts INSERT INTO dbo.ScottDateTesting (EffectiveDate)...

[--- 05Mar09 - If you've found this post via search, and don't want to read the long thread, scroll to the end for details of the resolution ---] (Sorry, I know this is a FAQ, I did search before posting...) Job layout: Seq File --> xfm --> DRS stage, SQL Server table DDL and test inserts via MS SQ...

Hi Ray, Yes the utility functions would be in the same file. I guess I'm used to more structured programming languages with variable scoping. I wanted to use the calling syntax of a function so I could use it in an IF statement, and any variables defined in the function would be out of scope when th...