MVSFORUMS.com

Thanks Kolusu!!! Thanks for Your Time and Help

Thanks Kolusu

But Number of rowes are limited 50 to 60 it is not going extend more then that, so that i am thinking to use SQL , Please guide me I am in the right Direction

Thanks
Cool

Hi all

in db2 I want to write a SQL that can take the values from a Table which has multiple rows in it and want to convert them to as multiple columns.

For example the table data from table A ...

Kolusu
You are correct. Thanks a lot.

Cool

Hi Kolusu

Thanks a lot for the kindly help but i am facing the other problem

I am using the code
ws-file-date pic x(10).
ws-fromdate Pic x(10)

SELECT DATE((:WS ...

Thanks Kolusu But i want to use date which i am reading from the file, not current date please help in this

Cool

Hi Friends

I want to calculate some Date funcion

1) I am reading the Date from the file and i and doing some calulations and add 1 day to the date and do the same calution , i want to do sa ...

Hi frineds I ahve a doubt in Dummy load
can we delete all the rows in the Table use Dummy laod(the Table cotains some not null fileds also)

Thanks Kolusu it is working fine

Cool

Hi all

I need a help

i working on SAS Migration projct

in SAS code

PROC SORT DATA=temp1; ...

Hi All

I have doubt in Arrays

In my program I have 2 arrays (2 dimensional)

Array Info (4, 49)
Array Amts (51, 49)
Both are different attributes
Can I pass this array value to my sub pro ...

Hi
I want the sample porgeam with multiple record format in cobol

Cool

Hi friends

Could you pls provide me any sample program with Multiple record format

Thanks
Cool

I in the appliction side only ,i am not having much idea about the DBA activity ,while doing this one i facing this problem that's reason i asked for some useful links

Cool

Could you please provide me how to connect with new DB2 table with our cobll db2 program Or do you have any document/reference link about it?
Please help in that