Search results for query: *

Hello every one, We have a hash partitioned table partitioned on columna and each partiton holds only 1 value ex: p1=x p2=y My question is would there be a difference in performance if table is acessed select * from table a partition(p1) vs select * from table a columna=x It would be...

Hello every one, Could any one of you tell me how do I spool the data from a stored procedure to file My requirement is I have to generate a merge_into script on the fly. I have to generate a script like. I was able to get the the column names and constraints from the data dictionary. I was...

Hello, Could you please help me answer the question I have a file like x y z I want it to append , at the end of each file except the last file x, y, z I am getting , at the end of each line with sed 's/$/,/' but I dont want it at end of the last line Thanks Could you please help me get this

Hello, I am trying to solve a problem to redirect output from a sql command to a delimited file I am doing db2 connect to $database user $username using $password db2 select * from x > file.out db2 terminate Export gives the choise but, I can use export as I dont have privilages,and it...