MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Search found 4 matches
MVSFORUMS.com Forum Index
Author Message
  Topic: Unload using Joins from DB2 table
vijay_bc

Replies: 3
Views: 4725

PostForum: Database   Posted: Sun May 13, 2007 8:02 am   Subject: Unload using Joins from DB2 table
Hi..

Is it possible to use Join in UNload utility while extracting data from DB2 tables as below? KEY1 being common in both tables. This syntax fails saying select is invalid. Can u suggest any opt ...
  Topic: moving values to comp-3 value
vijay_bc

Replies: 7
Views: 4270

PostForum: Application Programming   Posted: Wed Aug 23, 2006 11:08 am   Subject: moving values to comp-3 value
Hi Kolusu,

java front end always sends a complete string (with padded zeros).

The above stuff is working fine with the below piece of code

01 var-01 pic X(10)
01 filler redefines va ...
  Topic: moving values to comp-3 value
vijay_bc

Replies: 7
Views: 4270

PostForum: Application Programming   Posted: Wed Aug 23, 2006 5:59 am   Subject: moving values to comp-3 value
Hi
thnx for ur inputs. the above examples are absolutely fine.

here we have the actual scenario where we want to store the comp-3 value in db2.
VAR-01 is retreived from a java front end. it send ...
  Topic: moving values to comp-3 value
vijay_bc

Replies: 7
Views: 4270

PostForum: Application Programming   Posted: Tue Aug 22, 2006 12:10 pm   Subject: moving values to comp-3 value
Hi,

I want to do the below move operation.

**********************
01 disp-Variable01 PIC -9(6).9(2) value -000022.50.

01 comp-variable01 PIC S9(6)V9(2) usage comp-3.


Mo ...
 
Page 1 of 1
All times are GMT - 5 Hours
Jump to:  


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group