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 77 matches
MVSFORUMS.com Forum Index
Author Message
  Topic: Query to get the DDL sentence
monaco

Replies: 12
Views: 7018

PostForum: Database   Posted: Wed May 18, 2005 9:40 am   Subject: Query to get the DDL sentence
Thanks a lot for your reply.

They are very usefull.

Thanks a lot.
  Topic: Query to get the DDL sentence
monaco

Replies: 12
Views: 7018

PostForum: Database   Posted: Thu May 12, 2005 10:28 am   Subject: Query to get the DDL sentence
Hi,

we'd like to create an automatic process for getting the DDL. Imagine a pannel asking you the table name and the output is the DDL.
I thought there is a select (join of few tables) and just wi ...
  Topic: Query to get the DDL sentence
monaco

Replies: 12
Views: 7018

PostForum: Database   Posted: Thu May 12, 2005 9:52 am   Subject: Query to get the DDL sentence
Hi all,

Could someone provide me a the query for getting the DDL sentence of a simple table?
What i'm looking for is the sentence to the DB2 catalog (v7) where the result is for example:

CREATE ...
  Topic: Data comparision
monaco

Replies: 7
Views: 3988

PostForum: Database   Posted: Thu May 12, 2005 9:48 am   Subject: Data comparision
Thanks for your help.
  Topic: Data comparision
monaco

Replies: 7
Views: 3988

PostForum: Database   Posted: Wed May 11, 2005 8:46 am   Subject: Data comparision
Hope you can understand the example and sorry for my english.

I want to compare the data in two tables with the same structure. I'd like to know a ouput saying there are 3 rows in table 1 which are ...
  Topic: Data comparision
monaco

Replies: 7
Views: 3988

PostForum: Database   Posted: Tue May 10, 2005 4:01 pm   Subject: Data comparision
Kolusu,

We want to compare the 1st row of table1 to ALL the rows of table2.

Thanks.
  Topic: Data comparision
monaco

Replies: 7
Views: 3988

PostForum: Database   Posted: Tue May 10, 2005 12:18 pm   Subject: Data comparision
Thanks Kolusu,

the problem is we want to compare the data of two tables with the same structure but problably different data in each column.
We dont have a 'KEY' column.

We are trying to compar ...
  Topic: Data comparision
monaco

Replies: 7
Views: 3988

PostForum: Database   Posted: Tue May 10, 2005 11:47 am   Subject: Data comparision
Hi all,

is there any tool for comparing the data of two tables without downloading both into a differents files and compare these?

Kind regards.
  Topic: Bind version
monaco

Replies: 10
Views: 5138

PostForum: Database   Posted: Tue Apr 19, 2005 11:08 am   Subject: Bind version
Hi all,

after long time i come back with the FREE PACKAGE issue.

Could someone provide me an example about how to get the consistancy tokens from the DBRM library?
We think to use a REXX but it ...
  Topic: Record truncate
monaco

Replies: 2
Views: 1529

PostForum: Database   Posted: Thu Mar 03, 2005 10:06 am   Subject: Record truncate
Thanks Kolusu.
It works.
  Topic: Bind version
monaco

Replies: 10
Views: 5138

PostForum: Database   Posted: Thu Mar 03, 2005 9:50 am   Subject: Bind version
Thanks a lot.
  Topic: Bind version
monaco

Replies: 10
Views: 5138

PostForum: Database   Posted: Thu Mar 03, 2005 5:08 am   Subject: Bind version
Thanks a lot.

My address is:
david.san.servando@accenture.com

Thanks a million.
  Topic: Record truncate
monaco

Replies: 2
Views: 1529

PostForum: Database   Posted: Thu Mar 03, 2005 5:03 am   Subject: Record truncate
Hi all,

i'm trying to execute the file

1DSN SYSTEM(AISE)
1 FREE PACKAGE (POS3I.KEBLM004.(2005-01-20-18.19.39.357206))
...
  Topic: Bind version
monaco

Replies: 10
Views: 5138

PostForum: Database   Posted: Thu Mar 03, 2005 4:03 am   Subject: Bind version
Hi CZerfas,

is there any chance you can send me that process?

Thanks a lot.
  Topic: sqlcode 100
monaco

Replies: 2
Views: 2421

PostForum: Database   Posted: Wed Feb 23, 2005 11:21 am   Subject: sqlcode 100
Thanks a lot.
It was very useful.

Thanks Kolusu.
 
Page 1 of 6 Goto page 1, 2, 3, 4, 5, 6  Next
All times are GMT - 5 Hours
Jump to:  


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group