DSXchange

Hi, A search in this forum would have found this answer!!! As far a I remember, SP Stage currently works with Oracle only, should work with other DB vendors in the future, concidering the unfolding events DB2 should be the next supported DB . do read the docs on that stage (found on the install CD)....

Hi, IMHO, Ken's postings here are FAQ worthy. Regarding the bulk loaders I think a search will find previous topic on that and conclude that using the command line utility supplied with the DB client software is prefered over using the bulk loader stage (the stage is normally used to generate the da...

Hi,
Except searching for the answer in this forum....
you can use Iconv(...) to get the time to a DS internal representation subtract the time and use Oconv(...) to turn it back to timestamp format.
use the DS help on the mentioned routines.
IHTH,

Hi,
search in the forum.
I belive in a recent post Ray gave a link also to 1 of Ken's posts in this matter.
Please do search befor posting

Hi,
And the good thing is that from 7.5 the client switcher is actually a supported utility .
still only one version can be active at any givven time for the reasons ArndW mentioned.

Hi,
Just to add on the answer givven:
this option is available via director only if your project properties(set via DS Administrator) have the allow job administration in director checkbox marked.
this will also cause the cleanup resources option to be available.
IHTH,

Hi, In a simple description: when you use IPC stage your actually seperating a process into 2 seperate processes that comunicate via a memory buffer, one is pushing data into the buffer and the other pulls the data out of the buffer as it's input. the thing is that the processes are independant, the...

Hi, you can use also 1 of theese: 1. perform a lookup directly ti a DB stage and use a user defined sql implementing a between clause in your where part. 2. insert your values to a table, then use a sql join to unload a hash file with the original column from your source data as the key and the data...

Hi,
How about using the properties tab of the job and check the: enable hashed file chache sharing.
this should load the file to memory once instead of multiple times/
IHTH,

Thanks for the correction ArndW
Kinda hard testing and rechecking everything, I thought I remembered correctly but I guess I mixed something up there

Hi,
as ArndW said ODD !
Just to be sure check that you didn't run it in 1 project and looked in the other's log entries?!

Hi, when you readnext by key you get the reminder of the row returned without hte key value. you might also want to go over openpath and related commands in your BASIC.pdf file in the docs directory under your installation directory. you can also search this forum, there are previous posts for handl...

Hi, Job Controll meaning Basic?! in basic a parameter named SERVERNAME would be refered to as that exact name with no # signs around it, just as you'll notice it apears when you set a parameter value of a job activity in a sequence job that is derived from a parameter of the sequence job. so in GUI ...

Hi,
There will always be a case where:
You can't guard against your guardian,
that is why you make backups!

IHTH,

Hi, your NLS should be set to an apropriate value not UTF8 by default. there is also the off-chance you have a combination of NLS in different columns. first you need to identify which NLS you need and wethere it is consistant or a per clumn defined. in case you don't have an existing NLS that suppo...