DSXchange

Besides the fact that you have two "JOB3" stages, the last one needs an OK trigger if you want it to be checkpointed properly

It "comes out like that" because for some reason you have enabled (checked) the Disable BBCode in this post option.

Click on the Edit your post option, uncheck 'Disable BBCode' and all will be well. Or at least weller.

You might want to give this a shot, it sometimes works when a 'normal' reinstall doesn't. Uninstall DataStage. Remove any directory remnants from your hard drive. Use 'regedit' (if you are comfortable with it) to remove all traces of any Ascential registry entries. Reboot. Then lastly reinstall.

The job has no idea you are CASTing the data in the query. Fix the metadata in the stage instead. You are allowed to change it when appropriate, ya know.

What version of Oracle are you targeting? I'm surprised you got the Oracle 7 Load to work unless you have a 7 client installed, as I was under the impression that was a prerequisite. The Oracle OCI Load stage in 'Automatic' mode should be able to load data into Oracle as fast as you can supply it. W...

brunix wrote:I think too to use a Project level parameter, but I haven't permission to define it.

You mean you're not allowed to? Since you have a logon to the project, you can log into the Administrator and define a User Defined environment variable in your project. It doesn't take an admin to do that.

SQLBindCol: Failed to bind result set column 'o_st_uid' for SQL statement: SELECT o_st_eid from o_st where o_st_uid = ?. This implies you used user defined sql for some reason and did not match the columns defined in the stage to it. My first piece of advice would be to allow the stage to generate ...

I already explained how you can find out what information you can capture in the DRS stage. If that's not sufficient to your needs, then other approaches need to be considered. Sometimes the detailed information you are seeking is only available in the job's log after the job completes. This means b...

Greetings! And welcome. :D 1) What is the group column used for? when should it be used? One of the wonders of using a common 'widget' - not all columns are used in all circumstances. In this particular stage, that column has no function. 2) Is the 'Key' column the actual determiner of which columns...

Define 'appropriate'. Do you plan on doing something different in your job (other than simply reject errors) based on the type of error? Typically, you would endevour to craft your job such that the errors you listed would never happen. I personally would consider any of these errors 'fatal' and req...

Unfortunately, not all stages return all possible return variables.

If you've already found the DRS stage doesn't return values that you need, don't use it. If you are using ODBC and it works, why 'require' the use of the DRS stage? Push back.

With the ODBC you won't be able to use the NOTFOUND link variable. You typically give a constraint expression if you want a 'logical' reject - meaning, you want to avoid sending a row to the target that you know will cause a problem. A 'physical' reject doesn't need a constraint as it can catch reco...

First thing I'd try is a complete re-install of your client. Throw in the cdrom and install right over the top of everything that's already there.

ravibabu wrote:Can you use MERGE or JOIN stage .That can be helpful to you.

Not in a Server job.

Does this happen just for you (on your PC) or does everyone have the issue?