DSXchange

Hi, I've tried to use the KgdGenHtml and it works OK but seems like it is not generating the bmp images for each job, or at least they are not under ..\KimD\Jobs\ directory or anywhere else in the server. I've copied the DSaveAsBmp.bat and DSaveAsBmpDriver.bat to my local client directory C:\Program...

I need to know the DOS command lines to stop and start the DataStage services through a batch in a Windows server (it should stop automatically for mainteinance purposes) . I couldn't find this in the forum topics or documentation, only manual stop references. Could you tell me where to find them or...

I have a problem i'm tring to use a count distinct in an aggregator stage but i don't know how, because it is not a option in this stage, is there any other way to do this?? thnx

Excellent Ken, Thank you! One more question If I have some hash files identified and we want this in the new project what its the best practice to import to our new project (hash cleaned)... obviuosly we want to conseved it because takes a a long time to porcess this, we dont know may be with a flat...

HI! WE ALMOST FINISHED A DWH PROJECT AND WE WANT TO CLEAN ALL THE HASH FILES WE CREATE ON THE DEVELOPMENT PHASE AND BEFORE WE MOVE TO PRODUCTION. IS THERE A WAY TO DELETE ALL THE FILES IN AND ACCOUNT OR WE NEED TO DELETE ONE BY ONE (EVEN SOMEONES DONT HAVE THE NAME) ANY IDEA WILL BE APPRECIATED!!! R...

Thank you very much Ray, i find it.

Regards.

Angel.

Hi, i'm trying to use the commit in a ODBC stage, because the quantity of records are very big and make me slow the server, and if by some reason the execution failed the rollback take a lot of time to do, what i'm tring to do is taking a numbers of records and make the commit, write another group o...

Thank you, very much, finally y found the answered to my problem a head in the forum....greetings.

------------------------
Angel Martinez
Mexico

I'd like to know how can i call a Stored Procedure in a job, i want to use the stage StoredProcedure, but this only have the option of uns Oracle SP, and i want to call a SQL SP, thanks for your answers.