hi,
one small correction, I have to execute a set a queries and the output should be put into different text files.The name of these text files exists in another column of the table in which the SQL exists.
Search found 52 matches
- Sat Oct 08, 2005 11:36 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: executing SQL queries that are in a table's column
- Replies: 5
- Views: 1183
- Sat Oct 08, 2005 10:33 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: executing SQL queries that are in a table's column
- Replies: 5
- Views: 1183
executing SQL queries that are in a table's column
hi,
I am having a query which is in a column of a database table. Is it possible to execute it in DS?
thanks
vinod
I am having a query which is in a column of a database table. Is it possible to execute it in DS?
thanks
vinod
- Sun Oct 02, 2005 2:46 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: updating hash file
- Replies: 4
- Views: 979
updating hash file
hi,
how to update a hash file?
thanks
vinod
how to update a hash file?
thanks
vinod
- Sun Oct 02, 2005 2:38 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Dynamic SQL
- Replies: 3
- Views: 2810
- Sat Oct 01, 2005 11:22 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Dynamic SQL
- Replies: 3
- Views: 2810
Dynamic SQL
hi, I am having a mapping table consists of many table names and columns and these data were available in the database.Eg: tablename columns functype1 functype row1 x1 name1, Id1,sal1 y1 z1 row2 x2 name2,Id2,sal2 y2 z2 using functypes, tablename and columns have to identified and metadata of the tab...
- Tue Sep 13, 2005 5:36 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: seperating duplicate rows
- Replies: 12
- Views: 3695
- Mon Sep 12, 2005 7:29 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: seperating duplicate rows
- Replies: 12
- Views: 3695
seperating duplicate rows
hi DS Gurus, I want to seperate duplicate rows with following conditions, 1. seperate the rows which are duplicates Eg: if the values like this 2 2 2 4 4 5 5 6 7 then values should be thrown into rejection table in the follwoing manner 2 2 2 4 4 5 5 and the other table should have the 6 and 7 which ...