DSXchange

samyamkrishna wrote:Are you asking me to explain a bit more.

Yes.

It's one thing to say "do X" when it is obvious what that means, but a general statement like "use unix commands after job" should really be explained. IMHO. And I'm sure Mandyli would appreciate it as well.

You can't if the refresh interval is shorter than the amount of time it takes to display things, it just "hangs" and you never get a chance to work the GUI. Hence all the registry trips.

Sounds like something that's either a bug in the stage or something they don't support for some reason. Check with your official support provider, see if there is a patch available.

No clue, never had a need to come at it from the registry and I've got no system to play with and check. I'm also thinking that there may be some other 'trick' you can do to get access to this from the GUI, some other view or by setting a Filter that won't find anything... or... don't recall. :? I'd...

You might want to expand a wee bit on the how of that. Still better before job, IMHO.

The dsenv entry you quoted above for LD_LIBRARY_PATH doesn't seem to include anything Oracle related. And is that where ORACLE_HOME is set? As noted, don't rely on anyone's profile for this.

pandeesh wrote:I am not able to see the parameter APT_NO_SORT_INSERTION for that particular project. Does it mean that it's false?

Any boolean environment variable that is not set is equivalent to having it set to false, yes.

That... sounds like a question for your co-workers, DBA or Architect.

What happens if you turn off the refresh and then wait? And where are your logs stored, UV or XMETA?

Arg... people need to be more careful. Fixed.

Off the top of my head, perhaps using EReplace() but you may need to build a custom routine and do the replacement one character at a time in a loop. Easy enough to test and see, I would think. A minor nit, but you don't really need to convert any of the existing 9s so: Convert('012345678','99999999...

As far as I know, the same way as the first time.

Just to be clear, the client must be installed on the DataStage server and you have to configure DataStage by editing your dsenv file. Note that this has nothing to do with ODBC.

So, Server job as marked or Parallel as per the forum?

Ok... and?