DSXchange

Hi folks, I am trying to get the Current GMT Timestamp in one of my Parallel Jobs. The Target field is defined as a Timestamp on DB2 table. When i use the CurrentTimestamp() function i get the Current Timetsamp of the Server where the Job is running. Any ideas on how i can get the Vurrent GMT Timest...

Thanks Kumar for the quick response... I tried setting the Transaction Size = 1 ( could not find the option for array Size).. when i run the Job i get the following error and the job aborts... Stored_Procedure_14: [IBM][CLI Driver] CLI0125E Function sequence error. SQLSTATE=HY010 [IBM][CLI Driver] C...

hi all, I am trying to execute a Stored Proc using a SP stage/operator in a PX Job. My Job Design is ..Seq File -> Transformer -> SP Stage -> Seq file. The Source sequential file contains input to the SP. In the XFM i hard code the 2 output params that i have to use to call the stored proc.. When i ...

hi all,

i have a situation like this

fld
row1 a

row2 b

row3 c

row4 d

and i want the output as


fld1 fld2 fld3 fld4

row a b c d

basically a convertion from vertical to horizontal format...

how do i achieve this ??

Thanks

..already tried that..does not help..

hi all, I am having a Variable Block mianframe MVS data file, that i need to read. This data file has three types of records, each record of certain length. Example: Record A uses a Copybook X, record B uses Copybook Y and record C uses Copybook Z. How do i go about reading this type of MVS dataset,...

Hi all, I am trying to read in a Variable Block / EBCDIC mainframe file.. I was able to import and stick in the meta- data. Made sure that the Occurs clause is taken care of, by modifying the cobol copybook. When i try to read the data i get the following error.. "Error reading on import. Encun...

kumar,

there is no field in the metadata named "t.encoded"..

hi all, Job # 1 I am trying to compress a dataset A -- wriring it to a dataset named A_Zip.ds...it went fine... the metadata for A and A_Zip.ds is the same. Job # 2 here i am trying to Expand the A_Zip.ds...and trying to write it to another dataset called Result.ds the meta data for A_Zip.ds and Res...

people, Can we do an Update statement via DB2 Enterprise on a non-partitioning Key... I tried to do this but get an error saying that the partitioning key is not present...so is it correct to say that u have to have the Partitioning key in the where clause of the Update statement, in order t0 update...

the query is

Select
rtrim(ltrim(a.clmna))|| repeat(' ',30-length(rtrim(ltrim(a.clmna)))) as X,
rtrim(ltrim(a.clmnb))|| repeat(' ',30-length(rtrim(ltrim(a.clmnb)))) as Y,

from

DB_Test.Table as A;

the metadata for clmn X and Y is Varchar(30)...

..i have a user defined query that i am executing in my DB2 API, where i am doing a "left justify zero fill " of say a field X of Datatype Varchar(30).. I use the ltrim, rtrim, repeat , length functions and do a concatenation..the output is also a Char(30)...no probs..i am getting the desi...

if u get an alphanumeric value u shld be able to use the 'ereplace' function and eliminate the "0" char in ur string...but i think the trim shld work...

people, I need to get the diffrence between 2 date fields in Months..I can use the Xfm..but cannot use any user defined Qry..or touch any DB table... If the difference in Months is > 60..i need to set a Flag else Unset it.. The functionality shld be similar to something like If TIMESTAMPDIFF(64, CHA...

I am Joining two datasets in the Join Operator. The Join is an Inner Join on 4 Keys.. I am doing a Sort and Hash Partitioning in the Join Operator for both the Inout datasets.. I get the waring: Join_26: When checking operator: User inserted sort "Join_26.TM_data_Sort" does not fulfill the...