DSXchange

Hi,
Well I found some cases where you must use " instead of ' like in modify stage performing conversion functions some times.
I do not know yet the reason.
(1 guess is that no handling of or ignoring ' for some reason)

So always test your stage's behaviour
IHTH,

Hi, I had a situation once that regular cleanup deleted all my D_ files since they were more then 2 months old. So I went to delete/create to get the D_ access time up to date. Anyway, one phenomena was that instead of writing lines to the hash file each line became a file in the hash directory file...

Hi,
Just wanted to say I also use Craigs method.
It is dynamicly created at run time and you don't have to use/know DB specific syntax for "all" the ones out ther.

IHTH,

Just to be clear; If I run a rsh command from my DS Server on another machine, The DS Server waits for it to finish and only then resumes execution. Therefor the other machine is to be monitored as well as checking for some thing unusual in my DS Server (just in case). I would try finding alternativ...

Hi, IMHO, you need to monitor the machine running the remote shell command when it gets stuck, in order to figure out why it is stuck. Since you can't controll the remote machine, you might be better off with trying to ftp the file to the local DS machine and branch your job flow acording to the fai...

if there is 10 jobs in sequencer. while running 5 job got aborted. what will you further step that you will do thanks sivaji I can't help feeling like I'm in an interview for a ds developer position, being asked questions. If I'm wrong I'll be happy to help after you clearify and give more details ...

Hi & welcome abord ,

Can you explain more about the differences between the 2 runs you mentioned?

Hi,
SmallDateTime of MS SQL server is a TimeStamp field with limited range.
So read in the docs for exact lower/upper limits for that type in the MSSQLServer docs to see it you exceeded them.

IHTH,

Hi,
Dont forget every project needs to be, individually, set from the DS Administrator for specific group privilages as well.

IHTH,

Hi,
if your actually connecting to a SQLServer DB for your siebel despite the driver saying: hey it's not!
check you configured it correctly.
I'm not sure if a class A IP should be an issue.

Is the KOREA_DB connection working properly?

Hi,
Ray/Ken,
Are you saying that there is an unpublished server side export?

Hi, Did you ever successfully compile a job with transformer stage in your configuration? If not it is probably a compiler configuration problem, configure the project's APT vriables for compiler and linker in the project environment via the DSAdministrator and you should be fine if you have the cor...

Hi, I did a little test with a seq file I created having 1 row: 12,,12,12 reading it with column 2 as nullable and writing that file in direct link to another seq file only gave the nullable field with no null handling warning but the record was not rejected! So what is different in your case??? p.s...

Hi, IMHO (In My Humble Opinion), The best way if you want it handled with DS is to get your DBA to give you a user defined sql to refresh the Materialized View/s you need. Or to run a SP that does it. Ask your DBAs for their opinion (being thaat a pure DBA task). If you were saying you want to repla...

Kinda makes you think ...
Are you after Rays position as top poster by far ???
gotta give him some scraps for more posts LMAO

Just Kidding

Guessing a month tops till you pass my posts Arnd WTG (Way To Go !!!)