DSXchange

Hi,

I have a question regarding to bulkload.

Our datastage server and DB2 server are located on different servers
Is it possible to create INPDATA.DAT and ULOAD.BAT, etc at the DB2 server machine, i.e. to make export and load locally at the db2 server?

Thanks,

Carol

Hi, I was trying to call a shell script within job control using routine ExecSH. But it cannot pass the compilation stage. Does that mean I have to use ExecSH in before/After stage, if it does, how do I check the return status to know whether shell script is executed OK or not? Actually I am always ...

Hi,

Thanks for the answer. Now I'm having question about how to setup UV stage, according to help manual, the data source name should be set up in uvodbc.config file. How to setup in the file? How to link my hash with this data source name?

Can you shed some lights?

Thanks,

Carol

Hi, I have a question regarding Range Lookup. I have an input file which has a field called salary, I need to reference a table to find salary range key based on salary figure. The salary range table contains salary_range_key, min_salary, max_salary. Is it possilbe to use hash file to implment this ...

Hi Ray,

It worked. Thanks a lot.

Yiming

Hi,

I have a problem. When I used hash file as source to insert rows into DB2 table. If there is empty string, it will insert a very weird character in DB2 instead of leaving it as empty string.

Has anyone encoutered such problem before? What's the solution ?

Thanks,

Yiming

Hi Ray, Could provide more details about how to configure UVTEMP parameter? Is there a configration file under each project? Thanks, Carol It may simply mean that the /tmp file system became full. Use the UVTEMP configuration parameter to configure scratch space somewhere with more space than /tmp, ...

Hi, I had one extract job, which extracts data from source system, and dumps into hash file. The job was code to pull data of specific site specified in parameter. I also have a main job, in which the above extract job is called several times (depends how many sites I want to process) in a loop. It ...

Hi,

I was trying to open one of my jobs, but it hangs there, and my datastage designer friezes afterwards. I already tried to clear status file in designer, it does not work. And the there is nothing locked behind scene. Does anybody know what's the problem?

Thanks,

Yiming

Hi, One of my job was running endlessly. I tried to stop the job using stop command in diretor, unfortunately it did not stop. So I log to Unix box, trying to kill that process. But in director, it still indicated the job is running even though in Unix, I could not find this process. Is restarting D...

Thanks a lot. It works perfectly.

Hi, I want to read a hash file in a server routine. I know I can use the statement "READ FileRec FROM Handle, Key", but if I have mutiple keys, how do I specify them? I was trying to look for a document about how to read hash file using basic language, but could not get any. Does anyone kn...

Ken,

Thanks a lot for your quick response and superior knowledge. I am really impressed.

Yiming

Hi

I was trying to write a subroutine, the subroutine is going to execute a job, the job name would be passed through InputArg. But I had difficulty compiling this subroutine, it keeps saying DSAttachJob never dimensioned etc.

I don't understand why? And any solutions to that problem?

thanks,

Thanks, it works. Greatly appreciated.