DSXchange

Hi, I am doing a project which requires me to process a number of files. However, this processing requires me to delete the input file one by one once it is processed. e.g. I have input files: input1, input2, input3 After I process input1 using DS Job -wait -jobstatus I delete input1 before processi...

Hi,

Thanks for all the responses. Is there any way in DS to call DS Job importer and DS compiler from command prompt?

Hi, I would like enquire is it possible to pass in a job parameter to provide as a condition in a Transformer whereby rows will be filtered and rejected according to it? e.g. instead of putting SomeFunction(inputLink.name, jobParam1)=1 in the constraint box and pass jobParam1="TEST" when r...

Hi all, currently i encountered a problem whereby my server version 4.1 running on Windows Server 2003 will be down for unseen reason. Error encountered are as below : Failed to start service. The service did not respond to the start or control request in a timely fashion ( win32 Error Code 1053). w...

Hi Ray, where can i get the sort.pdf? I could not find it in the Client pc Manual folder.... Thanks There's a separate manual (sort.pdf) for the Sort stage. Among other things this reveals that the sorting mechanism is based on the UNIX sort command. The model for the Sort stage is the UNIX sort com...

Hi ,
Thanks.
I could not find anywhere that says what type of sort it uses and in deed datastage sort is very much slower den the other sort utilities i have used.
In comparsion of unix sort 4 min to datastage sort's 1.5 hr ( sorting on same fields).

Hi all,

would like to enquire the sort stage in Datastage is defined by Datastage or it simples calls the unix sort? Or it uses to sort utility the user is given eg.SyncSort?

Thanks

NO You must use the "DELETE.FILE filename" command because the project has a pointer (like a synonym) in the project. You will screw things up. Look at this post for more information: http://www.dsxchange.com/viewtopic.php?t=85364 Thanks for the article, it does help me to understand how ...

great i have managed to retrieve the list of hash files created in the a/c.. however, i could not find any datastage engine commands to help to remove the hash files. Thus, im wondering by doing the following commands rm D_<hashfilename> rm <hashfilename>/DATA.30 rm <hashfilename>/OVER.30 rmdir <has...

The easiest way, although hokey, is to go to DS Manager and import hash file definitions on the project. You'll get a listing in the dialog box of all hash files. Helpful if you want a list. Otherwise, you're going to have to learn the syntax to query the embedded database. so i need to use the dat...

Hi all,
is there any way we can view what are the hash files created directly in the account so that i can housekeep them?

Thanks

Thanks. :D My job shall clear the table and insert only one row. However i do have an after-job routine which only touches a file. Anyway thanks for the reminder Usually you have an array size and a transaction size setting for your database stage which controls how many rows are updated between eac...

Hi all, would like to ask whether it would be possible for a datastage job to abort with error even though the update in the database is successful? The update stage of the table is the last stage in the datastage job whereby oracle database(read) (reference) | sequential file -> Transformer - > ora...

Hi all, is there any way to implement security on Datastage jobs? Currently all users on my server can view each other's jobs although they could not save and compile . Is there any way so as to allow the user to be able to view, save & compile their own jobs only? Appreciate your kind feedback ...

Thanks Ray and ranjan! I have never taken any of the courses... therefore a bit stuck [xx(]