Set global variable from file

[samyamkrishna]

One of the ways would be to.

read only the field you need using a cut command in UNIX.
replace '\n' with a ','.
pass this as a parameter to the job or sequence.

[chulett]

I wouldn't pass a list of "50 or 101" values as a parameter in a job, you can build a string and do it I just wouldn't recommend it. In your shoes I would load those values to a work table and then change your SQL to be more like:

Code: Select all

Select * from table where field in (select field from work_table);

That would work regardless of the number of rows in the input file.

[chulett]

Can't? That's a pretty severe limitation if you can't build work tables. IMHO.

[samyamkrishna]

You can read only the field you need using a cut command in UNIX.
replace '\n' with a ',' and write the sql into a .sql file.

in the DB stage use read SQL from file option.

[naveenkumar.ssn]

hi

I would suggest you to write all the required columns in a temp table and then use that temp table data to get your required search

OR

use the looping mechanism , read the content of file one by one and then view the records either at one go or read all the data .

[ray.wurlod]

Get "them" to allow you to create and use temporary tables.