DSXchange

LONGs are not supported. Best you can do is define the field in DataStage as a BIG VarChar. As long as the actual contents of the field fit into the size you define in the job, you won't 'fetch truncated data'. If it don't, it will.

Not much else you can do about it, I'm afraid.

Just kidding Uncle Ray.

Nice to know what the fiddly bits are made up of. I've thrown this into my Favorites so I can find it again next time the need for this information comes up.

I personally wouldn't consider your (1) to be a method for 'releasing' code. Yes, it can be used for migrating components from one server / project to another. It is typically used for creating .dsx exports of entire projects for backup purposes. In my mind, however, there are too many things that d...

Basically in exactly the same place you'd find it on your client pc.

Check $ORACLE_HOME/network/admin unless it has been overridden by the use of the $TNS_ADMIN environment variable.

ray.wurlod wrote:They're not obfuscated. The key is made up of the client machine identifier, followed by the client machine name, followed (by a colon then) by the pid on the server of the agent dsapi_server process that is maintaining the connection to the client.

Sounds kinda obfuse to me.

Did you try searching first before asking? A quick check shows 27 hits in this forum using sort and filter as keywords.

rsrikant wrote:For 2000 what is the service pack i am supposed to have?

No clue as everyone here is on XP. I didn't even think 2000 was a supported client platform. Best to ask on ADN or wait and see if someone else here knows.

Are you running XP with Service Pack 2 on your client pc? That can cause the problems you are now seeing if you don't apply the "SP2 Patch" from Ascential's eServices support website.

Use three of them.

Exactly, thanks guys. I've had great success doing it in the Filter command of the Sequential file stage - and there are several good discussions on that subject here.

Actually, the Standard Answer I've seen on the forums here is to always answer 'No'. If you are being asked the question then you are in the wrong place, meaning not already in a 'project' directory.

The Sort stage isn't really the best option for sorting millions of rows. It tends to be slow and fall over. Better off to use your command line 'sort' command. In the meantime, the first change I'd suggest is to set the property of the 'Temporary File Location' in the stage to something like '/tmp'...

Sure! Try this! In the Transformer, don't right-click on the links themselves (i.e. the lines that join the boxes), click instead on the 'box' that represents the Hash stage lookup. Then you'll get Link Properties as one of the options. Also as noted, you must use a UV or ODBC stage to get the extra...

Plus the fact that in Version 7 the memory segment is 'configurable', so you could make it work.

Once you install Version Control, you'll have the appropriate online help and .pdf documentation you are looking for. As to the question of moving versions back into your development project to fix bugs found it test, it depends on if further development has taken place in the meantime and if you wa...