DSXchange

Each tool is a good tool. Each tool is in Gartner's top right quadrant. They involve a different mind set during design (simplified as top-down versus bottom-up) but should end up with the same solution from the same plan. Any person may prefer one over the other. Here you're likely to get a bias t...

Hi,

Try some other way..

Delete table <---> where 1=1


Is it help you..??

Hi, We don't need any other database for creating repository. DataStage has its own DB (UniVerse). We don't need to import table def for Sources and targets seperately. We don't need to create sessions,... then workflos... then worklets.. then workflows.... in different windows.... We don't need to ...

Hi...

I think, your PC disk format type might be FAT32. Try to convert to NTFS and reinstall DataStage .. I will work on WinXP prof, Window 2000 prof, win 2k server, win 2k Adv server. But only server jobs.

From Windonw 2003 server, we can install DataStage EE. Correct if i am wrong

I would do it with either the ICONV & OCONV combination or substrings; both will work efficiently and accurately. If your input data is always correct in the format yyyymmddhhmiss+nano sec and your output is in the form dd/mm/yyy hh.mm.ss.mmmm then your derivation would start off with the date ...

Eric wrote:Install DS 7.5 as you would normally
Install DS 7.5.1.a using the "-itag" option

Hi,

We have DS 7.5 on the server@AIX and i tried to install 7.5.1 client components. It is incompatable as concerned to client and server.

Cnu

With an array size of N you can get back a buffer containing N warnings. You can not prevent this. It's one of the down sides of using arrays. Thanks for your response Ray, But how can i stop generating log with out restarting the server. Please suggest me in some way.. Is it possible to give some ...

Hi, I am getting this error while running my job. Event type:Warning Message: Error occurred during link open processing. DSP.Open GCI $DSP.Open error -100. This is actually happend when i ran the job. Source and targets are DB2. I am loading the target table and if there is any error records, then ...

Thanks Bland, 1.) There are MACROs that can be used to generate dynamic results in fixed fields, such as filenames, that could do what you wish. There's certainly plenty of functionality in job control APIs and Sequencers to provide your functionality. 2.) There's always my favorite, write a standar...

I am also facing same problem. Here my intension is to pull all log to a file so that i can send it on mail.

The following is returning -13,

ErrlogInfo = DSGetLogSummary(JobHandle,DSJ.LOGANY,JobStartTime,JobEndTime,MaxLog)

Plz let me know how to write a routine!!!

Thanks,
BB

Hi All, I havn't used routines earlier, Could you plz assist me how to include some value in Job status in a job activity and how to retrieve in another job activity. ray.wurlod wrote: Use a job sequence to run the jobs. In the job that generates the value, have it also place the value in that job's...

Hi All, I was in vacation. Thats why i am unable to respond about this issue. I havn't used routines earlier, Could you plz assist me how to include some value in Job status in a job activity and how to retrieve in another job activity. Use a job sequence to run the jobs. In the job that generates t...

Hi,

Use FMT routine....

Example:

FMT( incomingField,3)

Hope this function will help you out

Srini
BB

Hi Guys, I have an small question. How can i change value of job parameter at run time. Here is the situation.. I had 15 stages in my job. In second stage, a value is going to generate. I need to catch that value and need to use in 15th stage for file name. So my intension is .... I will declare one...

Hi Mona,

It should be Meta data mismatch problem.. Correct length and scale to first field.


Srini
BB