DSXchange

Hi,

After installing windows SP2 i'm not able to view the properties of any sequencer job activities.

any clue would be highly appreciated.

Thanks inadvance.

I have a scheduled sequence job which is aborted after 50 warnings eventhough I have set the limit as No Limit.

Can't we set the limts on scheduled jobs?.

Thanks in advance.

Hi,
One of my Sequence job is got aborted in the production. This is the main sequence job.How can i restart my main sequence job automatically.?

Thanks in advance.

Is there another option for unzip to specify the target location? If not, change the command to cd pathname && unzip -o /TESTZIP/xyz.zip ... yes. I have other location to store the unzipped files.How can i do that?. How can i give morethan one parameter to Before/After subroutine?. Because ...

ArndW wrote:DataStage jobs shell out with a current attach point / working directory of the project that the job runs in. Check there for the output file. ...

Hi,

How can i change the directory in the routine. so that it can place the file where the zip file is.

Thanks in advance.

As Arnd suggested, add the Output variable to your error message like this Message = "Error when executing command: " : Command : Output and then see what exactly is causing the error. It will be easier to debug that way. Hi. when i use the option 'o' it ran ok. unzip -o /TESTZIP/xyz.zip ...

Hi,

How can i remove the unprintable characters from the input string.?

Thanks in advance.

Hi, Can you check with " SUBROUTINE unzip(InputArg,ErrorCode)" .In your code I do not see InputArg. I am not sure the error is because of this or for something.Post the error. SUBROUTINE unzip(InputArg,ErrorCode) Command = 'unzip /TESTZIP/xyz.zip' Call DSExecute("UNIX",Command,O...

It would be very helpful if you could actually tell us what the error is. You should also include the contents of the variable Output in your error message. ... It doesn't say anything. But it always logs it as warning with the message Error when executing command: unzip /TESTZIP/xyz.zip. why it is...

Hi, I have written a Before/After Subroutine as below. And it is errored out. SUBROUTINE unzip(InputArg,ErrorCode) Command = 'unzip /TESTZIP/xyz.zip' Call DSExecute("UNIX",Command,Output,SystemReturnCode) If SystemReturnCode <> 0 Then Message = "Error when executing command: " : ...

The compiled routine is requiring 3 arguments per the message. Check the routine and if necessary recompile it. See if the job complains again after you recompile the routine. If this is a standard before/after Routine there are only two arguments allowed, it it's a custom Universe function then mo...

DataStage Job 508 Phantom 12192 Subroutine "DSU.ReadRecords" called with 2 arguments, 3 were expected" Program "DSU.ReadRecords": Line 13, Unable to load subroutine. Attempting to Cleanup after ABORT raised in stage COV..xfm_COV DataStage Phantom Aborting with @ABORT.CODE = ...

Hi all,

Is tehre anyway that i can find a last row number ina sequential file which can be used in constraint as @OUTROWNUM = Lastrownum?.


Any input would be highly appreciated.

Thanks in advance.

Hi all,

How can i load a text file into an ORACLE database as a column?

I would be grateful if anyone could shed some light on this.

Thanks in advance.

Hi ray, It doesn't solve my problem. Is there any way to find out a file has Line Termination of UNIX style or DOS style or None.? I would be grateful if anyone could shed some light on this. Thanks in advance. Open the Columns grid, scroll right and find where you can set the "column contains ...