DSXchange

"high" and "low" values are a COBOL concept - is this data going back to COBOL? You will need to check what the EBCDIC "HIGH VALUE" is and either use that value in a binary field, or use the appropria ... We will have both scenarios , first output will be used for our ...

What is your job design? What stage types are you using? Under what conditions do you need to assign a "high value"? Have you decided what "high value" means/is for each of the data types you are u ... Parallel job reading data from Asci file , use a transformer , write data bac...

How do i assign a column with a high value ,, if my output column is col1 , part of asci or ebcedic file ?

thanks

SO , do you recommend partioning the data ( HASH ) based on the key , before we sort it , then remove the duplicate ? No. (Auto) leads to Round Robin except: on reference input to Lookup stage - Entire on inputs to Join and Merge stages - Hash on join key(s) on DB2/UDB Enterprise stages - DB2 on ot ...

Hi; Thanks for the response , Yes i did partioned the data and hash sorted records based on the same key .. i guess now am seeing the data different. Its corrrect now. thanks Composite keys are fine. Are you data partitioned, as well as sorted, on these key fields? Not being partitioned on the keys ...

Its so funny , how this component act on data ,, am passing data with 4 columns key to this component , and guess what ,, it doesnt catch the duplicate !!! thats funny example : we have an input stream with keys col1,col2,col3,col4 inside the remove duplicate component m , i do sort based on those k...

chulett wrote:If you want to get clever, build a job to pull the relevant parameter info out of the extract(s) and load it into a database - then query away! ...

when you have a project with 100 jobs its hard to trace , which job is this parameter belongs to ,, its gonna take long time i guess ,,

chulett wrote:Export the project and search the resulting dsx file. ...

what i need is to be able to search within all projects , not just within 1 project , if that is possible.

ArndW wrote:Would you be looking for the default value in the job definition or the historical values actually used at runtime? ...

am looking at the default value in the job definition

Hi All;

Is it possible to search a job parameter value within all DS jobs.

for example , if i have a user variable name : v_table_name with a value of : table_1 in one of my DS jobs , and i wanted to see all other DS jobs using that parameter value ,, how would i go about that ?