DSXchange

Sorry for what is likely a simple question. I searched on "function" before posting but got 4500+ hits, and the Basic doc is unclear. Couldn't find it on Google either. So...can I declare and use utility functions within a function? What I want to do is something like: * Declare function (...

Hi, FWIW, I did read the doc and searched the forum before posting. If the answer is in here I missed it... Does DS have an internal timestamp (or what SAS calls a datetime) format? IOW, if (straight from the doc): X = Iconv("1997 5 27", "D YMD") X = 10740 and X = Iconv("02:...

1. Yes, things are always easy to do when one knows how to do it. Would one of the "many who have do so" care to chime in with the details? 2. In the previous post I supplied the link for, it was for parallel jobs; does that post also apply to 7.x server jobs? 3. If it is so easy to do so,...

Hi, Say I have a CSV file like so: Foo,Bar,"Unit 1, 234 Main St, Sydney",Blah With the correct sequential file link format parameters, this will become: Col1=Foo Col2=Bar Col3=Unit 1, 234 Main St, Sydney Col4=Blah I have a requirement to ensure the input file has the correct number of colu...

Update: 1. The doc is woefully inadequate in defining the difference between "Map empty string" and "Pad with empty string". I've done a search on all documents under C:\Program Files\Ascential\DataStage7.5.1\Docs and only get one hit in the Server Job Developer's Guide. Here is ...

Hi, I'm reading a tilde delimited file like so: Col1~Col2~Col3 << header, A~~C So, Col2 is missing. I need to validate the data in Col2 with data in another table (SQL Server, I'll call this table Lookup, and the lookup column Col2_NK). So, I use a reference lookup in the transformer. Both columns h...

Hi, I received a PM requesting more detail on how I got this to work (with the help of this list, of course). I thought it would be useful to disseminate this to the forum in case it gets a search hit in the future. I created the below as a test case: 1. I created the function UserStatus and saved i...

Hi, I have stage variables used for data validation like so: C1 = If IsNull(Foo) Then "Null Foo;" Else "" C2 = If IsNull(Bar) Then "Null Bar;" Else "" C3 = If IsNull(Blah) Then "Null Blah;" Else "" ... Cn = more data validation ... Then... ...

Thanks for the tip Craig. Much appreciated. I've compared the two database object types, and will look to change our database objects from ODBC to DRS (this is all new development so is easy to change). It looks like the DRS object may offer some slight performance improvements as well.

Hi Craig, I tried dragging the repository data onto the link but, unfortunately, this exhibits the same characteristics as the Load... button. I've tried hacking up the imported metadata: * Open each imported table, change Datasource name from Catalog_DEV to Catalog. This creates a new category (fol...

Say I import SQL Server table metadata using an ODBC definition. Later, I load column definitions for a link via the Load... button, then select the appropriate table metadata. The generated SQL is something like: SELECT APPNAME.dbo.Scott.SK, APPNAME.dbo.Scott.NK1, APPNAME.dbo.Scott.NK2 FROM Scott W...

Hi, 1. Can a routine query a database and return a single row/single column result set to a parameter? If so, does anyone have example code that does this? 2. Can a routine query a database and return a single row/multiple column result set to multiple parameters? If so, does anyone have example co...

Hi, 1. Can a routine query a database and return a single row/single column result set to a parameter? If so, does anyone have example code that does this? 2. Can a routine query a database and return a single row/multiple column result set to multiple parameters? If so, does anyone have example cod...

Welcome aboard. The short answer (which a Search would have revealed) is that there is no legal way to change the value of a job parameter once that job is running. The usual "solution" is to carry dummy columns containing the information; this approach is essentially cost-free. Hi Ray, T...

Hi All, I'm new to Datastage, although familiar with other ETL tools. If I post a FAQ, feel free to just point me to a link or give me the correct search string to use in the forum. Scenario: Table1 (small, in SQL Server): Date IsCurrentPeriod 2009-02-11 N 2009-02-12 Y 2009-02-13 N Table2 (huge, in ...