DSXchange

In which guide of DATASTAGE is DS_JOBOBJECTS discussed???

Hi,

How and where does DataStage store Annotations and data regarding the "Performance Statistics" ?

When i store the Column definitions in the repository how does DS store them???

Is there not any meathod with the UV tables???

Yes it is hard coded.

Hi,

I have a project containing about 250 jobs and i need a list of jobs using the hash file 'xyz.hs' , how can i find this ????

Same as above case but using a seq file 'xyz.dat', how to know the job names???

Hi,


Where can i know the username who created the job?

Hi,
I have used a parameter of Encrypted type, say the value passed to it is "XYZ" and think for a moment that it gets encrypted as "##$%!!" now i want to view this value ""##$%!!" , then how can i do that.

I am trying to understand an existing job . the job is working perfectly, but how???

I am reading the seq file by putting 'tr -d '\015\010\007' in the filter tab.
I guess this command will delete all 'new line' (enter key) characters from the file. now my question is , how is the file being read as the terminating character is deleted from every record. The final delimiter=end .

I have tried as posted, its triming only the leading spaces but the trailing spaces still remain untrimmed. please suggest............

Does pipeline parallism exist in server jobs?

If i have set array size=20 and transaction size=13 after how many records would the insert commit?

if i have set array size=13 and transaction size=13 after how many records would the insert commit?

I have seen that in an odbc stage there are two update actions
1) clear table then insert rows
2)Replace existing rows completely

can anyone tell me whats the difference b/w the two?

I need to create 2 hash files. one based on integer key and another on character key, so out of various hash algorithms which one's should i use to create the above hash files?

*Topic Relocated to correct forum - Content Editor*

I am having a hash file with IP_ID, IA,ID as the key columns and there are some records with spaces in these columns comming from source . I am trimming those columns and writing into the hash file from a seq file. The problem i am facing is that after triming the columns are not containing blank sp...