MVSFORUMS.com

Manesh

Try this:

ALTER TABLE TABLE_NAME
ADD COLUMN NEW_CLOUMN_NAME1 DECIMAL(11,2) ;

ALTER TABLE TABLE_NAME
ADD COLUMN NEW_CLOUMN_NAME2 DECIMAL(11,2) ;

Kolusu

Thanks for your quick reply.

I did see this example earlier, but what I am looking at specifically is for the SYSUT1 input data set as a full image copy of THE ENTIRE PARTITIONED TABLE SP ...

Hi

In our shop, we recently migrated CA-Platinum for DB2 to IBM utilities. Some of the production table-spaces are partitioned, and CA-Platinum earlier provided options to recover the entire partit ...

The position number always refers to the very first column being selected. In my example, it is BANK_NUMBER.

The execution environment is CA-PAN/SQL add on working against DB2 V8 Data Sharing Group ...

Kolusu

I've used the following statement to include the DCLGEN equivalent for EASYTRIEVE.

SQL INCLUDE LOCATION W FROM AIDABPTS.IDA_ACCT_MSTR_IDX

This enables one to use COLUMN names a ...

Kolusu

Thanks for the response. The second library in the STEPLIB concatenation does contain DQSPSCV module, as seen from the screen print below.

//STEPLIB DD DISP=SHR,DSN=CA.EASYTREV.TST1.V6 ...

Vivek

True, even I have seen the PARM LINK statement at the beginning of few EASYTRIEVE programs. However, my understanding is that PARM LINK terminates execution after the completion of syntax che ...

Hi

Our shop uses CA-EASYTRIEVE PLUS-6.4 extensively in PROD environment for reporting and other utility jobs, limited to Q/VSAM file sets. Recently we installed the PAN/SQL Interface add-on to enab ...

Thanks Kolusu for your response !

I agree to what you mentioned on the number of columns in the result set. I guess I need to take care of the following for better performance:

1) Ensure that ac ...

Hi

Please can someone help me with the following query in DB2 V7/8 for z/OS?

I understand that a JOIN on two or more tables begins by creating a result table, which is a cross product of the bas ...

Thanks for your response, warp5 Very Happy

!! Your first suggestion definitely seems promising. We can not use the other suggestion for the following reason:

Assume that the first user signs on to CICS an ...

Hello

Please can someone help me with the following query?

Our system utilizes this area to authenticate each user signed on to an application. It's populated when users sign on to the applicati ...

If File-Aid and/or IAM file dialog is installed at your site, you could look up the KEY information in either of these applications. Otherwise, you need to refer to the KEYS parameters specified when ...

Kolusu

Thanks for your response. That explains it all.

Regards
Ram

Hi There

I was wondering if someone could answer the following query regarding one of the COBOL compiler options (NUMPROC) and its implications vis-a-vis S0C7/ASRA abends in CICS.

Consider the f ...