Search Results

@Jim ..Thanks for the reply sorry for the confusion.

[\\psoft8]this is the windows server and Is OBSELTE NOW .. the proposed process is to place the file from unix server to Mail box location ftp...

Hi All,

I have a current Process that runs "windows script " for the file movement that needs to changed to a "DataStage Process (Using shell script )"

Source :Text file is getting generated...

Hi ,

For the DB2 table export :I am looking to execute sql query from a (.sql )or a parameter file (which has "query=" SELECT statement" ) file using (ksh) unix script that is used by Batch...

@Corona688

Thanks.. can you please give me some sample code for the data extraction

How to execute your code then ??
using the command line
db2=>
or any other mechanism to unload the DB2 tables ??

Here we are specifying "sql query" in the script itself ..if it is a small we can accommodate here
Requirements:
We have multiple tables of same format to unload:-
so we want to modify the query...

Hi,
Parameter file is of format (.ini)consist of Properties and directories:
name=value
Query=select colA,colB FROM schema.tablename (i.e actual query to pass for the table)

I think above...

Hi ,

I Have following requirement:

DB2 Sql query to pass from a parameter file
for example, I would create a parameter file with (SELECT column 1, column 2 FROM Table name) then job would...