Search found 52 matches

by vinodhraj
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

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.
by vinodhraj
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
by vinodhraj
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
by vinodhraj
Sun Oct 02, 2005 2:38 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Dynamic SQL
Replies: 3
Views: 2810

hi ray,

If Iam having the mapping table and related tables in txt files, is it possible to achive in routines. if so pl. guide me

thanks

vinod
by vinodhraj
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...
by vinodhraj
Tue Sep 13, 2005 5:36 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: seperating duplicate rows
Replies: 12
Views: 3695

hi deepak,

u have told using stage variables, duplicate can be removed by the above conditions. can u please guide me how to proceed. i have visited forum, but i cant.

Is there any way to use count function in transformer?

thanks

vinod
by vinodhraj
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 ...