UV command

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
iskapalli
Participant
Posts: 76
Joined: Wed Jul 25, 2007 12:36 am

UV command

Post by iskapalli »

Call DSExecute("UV", "CREATE.FILE ":PVFile:" 30",Output,SystemReturnCode)

my unserderstanding of above command is

1. This is the UV command.
2.I will create hashed file by useing CREATE.FILE command.

I have some queries in the above query.

1. what is the mean by 30?
2.where this hased file will store(path).
3.what is the command to see the file and where I need to execute this command.

Please correct me If I am wrong.
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Type 30 is a dynamic file, the hashed file will be created in the project directory(you will get a file "D_MyFile", a subdirectory called "MyFile" with 2 visible files and a hidden file).
"see the file"? That would be from the TCL command line using "LIST" or the SQL-DLL "SELECT" command.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

UV is not a command, it's a shell.

Assuming the CREATE.FILE command was successful, you can query the hashed file. For example:
SELECT * FROM <<PVFile>>;
(subsititute the appropriate value for PVFile here.

Of course, since you have not populated the hashed file, 0 records will be selected.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply