DSXchange

well these are not user defined variables but environment variable(something similar to $APT_CONFIG_FILE), which i want to use in my job.

Thanks for the post chulett. However, these are the environment variables used to start the debugger. but when i check in the administrator these variables are missing. So, I wanted to know how do i add these system defined environment variables?

Thanks

Hi,

Could any one please let me know how do i add the variables like $APT_DEBUG_OPERATOR, $APT_DEBUG_PARTIOTION in the administrator by default I am not able to find it. and are they all applicable for the parallel jobs?

Thanks,
Waseem

Thanks guy's for your quick replies - CHeers!!!

Hi ,

Could any one tell me where can i find the definitions of all the system variables and usage scenario's where it would be optimal to be used?

As usual I hope i would get some help

Thanks,
Waseem

well sorry mate - I dont want to post the query. I would appreciate if i get a new way to think ahead. Anyways, Thanks for your help.

well, I am using time field to match time field and Date field to match date field. the output format of the fields is perfectly alright( As i have already checked in the peek). Also, as a second exercise I have replaced the column names with the output values of the peek stage and Still the job goe...

Well, these are the stops i have already executed. just before the db2 stage i split the data and routed to seek stage and captured the output. Now i substitue the column values derived after transformations into the query and run it from the DB2 prompt - Bang! It works like a charm. at the same tim...

Hi, when i am trying to run the update command in db2udb enterprise stage i am getting the below error. But for sure i know that there exists rows in the target table matching the where condition. the error i get is sqlcode=100, state=HY000, message=[IBM][CLI Driver][DB2/AIX64] SQL0100W No row was f...

Hi,

Can some one tell me how to Calculate week number(ISO FORMAT) of a given date considering thursday as the start of the week?

Thanks,
Waseem

Hi All,

Thanks a lot for the answers. :D

Regards,
Waseem

Hi Experts, 1. What I understand for the sort stage is that the pipe line parallelism is restricted while using sort stage. Would it be of any help if i go for hash partitioning in the sort stage? 2. I have a series of join stages one followed by another. I have sorted the data and hash partitioned ...

Hi,

Is it possible to define the column structure(meta data) in a file and then import it? if it is possible, then what is the structure of the file should be and how do i import that?


Thanks,
Waseem

Thanks for the replies. It seems I am not sure in my first post.

It can neither be positional nor on both the keys. One way is to join on the first key and then filter out the data but by doing so i would have the cartesian product created and then the data would be filtered out. So, I want to avoid the cartesian product.