Search found 3 matches

by namtrinhthanh
Wed Oct 04, 2006 1:01 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to remove extra lines in the output file?
Replies: 6
Views: 1862

I have found the solution, we need to include this command in the script file: SET VERIFY OFF.
by namtrinhthanh
Tue Oct 03, 2006 7:37 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to remove extra lines in the output file?
Replies: 6
Views: 1862

Thank you, Ray! Could you tell me some examples about the switch in the shell? I do not know how to find those switches.
by namtrinhthanh
Tue Oct 03, 2006 1:42 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to remove extra lines in the output file?
Replies: 6
Views: 1862

How to remove extra lines in the output file?

I want to extract table from Oracle using DSExecute and sqlplus as below: cmd = "sqlplus -s ":userID:"/":passWD:"@":dbName:" @":sFolder:"\eAccountBilling.sql ":extractDate:" > AccountBilling.txt" Call DSExecute("NT",cmd,output,rc) I use one parameter extractDate to pass to sql script file eAccountBi...