DSXchange

Or don't even bother with DataStage just to do this. A nice little korn shell script wrapper that executes the stored procedure using sqlplus (or whatever) would work just fine, too.

Not without more information. Is this the first time you've tried to use an OCI stage in a job? Have they been working before and no longer work now? Other OCI jobs work fine and it's just this one? Is the OCI plug-in properly configured in your dsenv file and pointing to the appropriate ORACLE_HOME...

I've never done anything special to 'maintain' any Version Control projects.

I've only seen that when you mix OCI8 and OCI9 stages in the same job.

Are there any 'transformations' involved? If not, I wouldn't even use DataStage for something like this.

In order any Datastage job through Unix command line.. you have to give dsjob command from the Datastage bin directory.. If you look at what was posted, you'll see that the OP did just that. It found the dsjob command, tried to execute it and promptly failed. I'm betting because of the issue that A...

Welcome. Looks to me like you are not running this from the UNIX side as a user that is not 'DataStage aware' for lack of a better term. Typically, users that will doing things like this will be setup to do this automatically in their .profile - you need to 'source' the dsenv file first. Try this: c...

Exactly. Since you have no opportunity to manipulate the value of the parameter in the job before it must be used in the stage, then you must do that outside the job and pass in the substringed result ready to use.

You could try searching the forum. You're not the first person to encounter this message and you'll find at least seven posts with that exact phrase in it. Typically you are trying to access a NUMBER or a LONG data type. Some can be corrected via the metadata and some fields the OCI stage just doesn...

Many of the plugin stages on a UNIX server need to be configured before they will work correctly. This includes, for Database stages, the libraries where their client software can be found being added to the SHLIB_PATH (or equivalent) environment variable in the dsenv configuration file. From memory...

Nope, sorry... still saving up for the pony.

True, but they meant on the Home Page. I'd agree, you could replace Points with Posts there and be better off. Still don't know what's up with the whole point system anyway.

Search is your friend as this has been covered several times already. I did a quick search for the keywords julian and iconv and many hits came up - including this one which should help answer your question.

So, you'd want all of these 'non-grouped' fields to have the one grouped field repeated on each record? I'm a little lost here. If this is really what you meant, I'd think you'd need to make two passes through the data - once to get the sum per 'key group' and then another pass to associate that sum...

poorna_76 wrote:Is there any limit on no of versions a job can be there in VersionControl tool?

I'm sure there is but can't imagine those limits ever come into play.