DSXchange

Hi Ray,

We tried executing by setting job NLS to NONE, still the issue exists.

Hi Ray,

In version 7.1 Windows OS the NLS is not there.
we copied the hashed files from 7.1 to 8.5 through winSCP in binary mode and processed it using fnuxi command
and the default nls setting is ISO 8859-1 for the job

Thank u

I have a similar issue..can somebidy tell me if we can use a environment variable or some configuration setting , where we can fix this double column and the data read is corrrected.

Its not easy to cast every column in a job as we have lot of jobs in the project.

Hi, We are migrating to DS 8.5 and the jobs which are working fine in 7.1 are failing in 8.5 because the column which are defined as double are getting trailing zeros. Whenever we change the column type to decimal...the problem get fixed and then in the same job the problem comes again with another ...

I'm not sure if I understood - you got the same error message but the DSParams file is still present with 777 permissions and a last modified date a long time in the past? Also, there should never be a DATA.30 or OVER.30 in the project directory itself, only in the subdirectories. I had a smilar is...

Ray, thanks for responding. The solution turned out to be very simple. It appears that while in the process of moving files I inadvertently copied a .Type30 file to the main project folder. Apparently this is a bad thing. I removed the file and all is well. Thanks guys , This post solved the simila...

Adding checkpoints gives the Sequence the ability to be restartable, but whether you can or not depends on the Status it ends up in after a failure. It must be in an "Aborted, Restartable" status otherwise you'll manually need to Reset it before you can run it again. Assuming here we're t...

The job is not getting reset after the abort even though the below option is checked "Add checkpoints so sequence is restartable on failure". The error is see in the job is JobNumber=9, TraceLevel=0/50, JobInstance=1 <<Jobname>> must be reset before it can run I looked at all the option bu...

Good. We've established that the command can be found. We've also established that the syntax of your sqlplus command is incorrect. Does this form of the command (redirecting stdin) work from the command line? Hi, I looked around for the solution and here is what i found from the forum. I can run t...

Tell us the error message so that we don't need to waste time guessing. My guess is that the PATH environment variable is not set to include the Oracle bin directory for the user that executes DataStage job. This is the Error message I got. CmdOutput contains :Usage: SQLPLUS [ [<option>] [<logon>] ...

What is your actual requirement :? and why would the sql file not work for you :?: Just curious as there may be a better way based on your requirement :!: I want to check some data through table query and based on the output of the query I will be executing another job. I do not want to add any obj...

Try this: Call DSExecute("UNIX", $ORALE_HOME/../sqlplus/$COMMAND , Result, ReturnCode) Thanks for you reply, I tried the below mentioned command and it did not work. BuildCmd =sqlplus ETL/ETL@MIRDB.PRD select * from dual call DSExecute ("UNIX", BuildCmd , CmdOutput, CmdRetCode) ...

Hi ,

Can anybody tell me, how can i run a SQL query in JOB CONTROL. I need to run the SQL query in Job control and capture its output and based on the output I need to kick off another job.

Please advise

Thanks

chulett wrote:So... resolved?

Yes, I will consider this as resolved as we do not have any option other then using eReplace or use different delimeter type.

Thanks once again for everyone's input.

chulett wrote:Not just "should be" but can only be a single character.

Thanks a lot everyone for your input. I appreciate your quick response.