DSXchange

The command is: E:\Progra~1\Ascential\DataStage7.5.2\dscc /H server-name /U xxx /P xxxxxxx project-name /J ETLSAP\* This is for compiling category ETLSAP, in propject project-name. User xxxx, pwd xxxxxxx. This is running in server server-name where is installed DS7.5.2. I connected remote to the ser...

Hi, there.....

I am compiling jobs with dscc.exe command line, but I get an error message when I run the command. The message says something like the logon is invalid, but this is not the real error.

Is there a known fix for the command line dscc.exe in DS 7.5.2 ?

Thanks in advance.

Finally, I could find the page where the STAUS fields are explained.

Thanks to everyone.

:D

Hi.

I need to retrieve the creation date and the last modification date of a sequential file.

I didn't find if FILEINFO or STATUS functions can retrieve these values.

Is there any other function to get the creation date and the last modification date of a seq file ?

Thanks in advance.

I got the answer. I edited the *.DSX file (the file generated by the EXPORT process), and I discovered that the original address was stores within the file, in another parameters that I cannot change. This is the line of the EXPORT file: Value "DSPASSWORD=\(A)RFCSERVERCOUNT=1\(A)SAPROUTERSTRING...

Hi, my friends.... :) I am exporting a job, within the same server. The original job accesses to SAP client number 221 with a given IP address. When I import the job to the new project, I have to change the SAP address where to access. When I change the address, I click the "validate" butt...

Thank you very much, Craig.

I'll try to develop the DS job to list the DS_AUDIT table. I know that this is not an easy task, but I will try.

Thanks, Ram and Craig.

Do you know the format of the DS_AUDIT table ?

Hi, my friends....

I'm looking a way to know each job modification date (server or sequencer).

If I compile the job today, I can see that the Date/Time modified (within Manager) is set to today date.

Is there a way to get the real job update date and time ?

Thanks in advance.

Thanks to everybody.

Finally, I could delete the job and recover it from a backup that I had taken.

I will try the CLEAR.FILE when I can do it.

Thanks again.
:D

Hi forumerssssss.......

I have a HUGE log (greater than 2Gb), and I want to delete it. When I try from the Director, my machine hangs on.

How can I do to clear the job log ?

I'm in DS 7.5.

Thanks in advance.

Hello forumers..... I'm getting the weird message when I'm trying to access a PROGRESS database (inserting records), from an ODBC stage. The message says that "Not all parameters were bind by the application". Is there anybody who has experienced with PROGRESS DB ? Any help will be appreci...

Thanks to everybody who participated in the answer.

I will try the DS* routines.

Have a nice day.
:D

Ray:

I apologize by the text of the original note. May be my translation to english was no good.

Can you tell me which DS tables should be included in the process that analyzes the running jobs ?

Thanks in advance.

Obviously is not clear what I need.

I don't want to look at the Director screen.

I want to have a job, running and detecting automatically when an Aborted job appears. So, this job should retrieve the list of run jobs, and analyze the status of each job.

Is it enough ?