compare contents on two tables using a cobol program



IBM's flagship relational database management system

compare contents on two tables using a cobol program

Postby sid714 » Mon Apr 29, 2013 4:08 pm

there are two tables with one same column in both the tables i want to compare those both tables and access the data which satisfies the comdition by using a cobol program?
can any one help me out with this
plz
sid714
 
Posts: 3
Joined: Mon Apr 29, 2013 4:01 pm
Has thanked: 0 time
Been thanked: 0 time

Re: compare contents on two tables using a cobol program

 

Re: compare contents on two tables using a cobol program

Postby Robert Sample » Mon Apr 29, 2013 5:10 pm

This is a HELP forum, not a WRITE-THE-CODE-FOR-YOU forum. What have you done so far and where, specifically, are your questions -- coding the SQL? coding the compare? how to retrieve the data? something else you have not explained? If you ask for code, be prepared to pay for the professional work product you are asking for -- and rates typically run 1000 US dollars (or equivalent) and up per day or fraction of a day for code.
Robert Sample
Global moderator
 
Posts: 3367
Joined: Sat Dec 19, 2009 8:32 pm
Location: Dubuque, Iowa, USA
Has thanked: 1 time
Been thanked: 222 times

Re: compare contents on two tables using a cobol program

Postby NicC » Mon Apr 29, 2013 5:56 pm

Or is it in the COBOL logic - in which case why post here and not in the COBOL forum?
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 2690
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisys (almost)
Has thanked: 4 times
Been thanked: 105 times

Re: compare contents on two tables using a cobol program

Postby sid714 » Mon Apr 29, 2013 8:48 pm

i m looking for the solution not code.so first of all just see want i m asking before u reply
sid714
 
Posts: 3
Joined: Mon Apr 29, 2013 4:01 pm
Has thanked: 0 time
Been thanked: 0 time

Re: compare contents on two tables using a cobol program

Postby sid714 » Mon Apr 29, 2013 8:51 pm

NicC wrote:Or is it in the COBOL logic - in which case why post here and not in the COBOL forum?

thanks for ur advice so u dont knw how it work
sid714
 
Posts: 3
Joined: Mon Apr 29, 2013 4:01 pm
Has thanked: 0 time
Been thanked: 0 time

Re: compare contents on two tables using a cobol program

Postby Robert Sample » Mon Apr 29, 2013 9:14 pm

If there is only one row per table, retrieve and use the COBOL IF statement. Otherwise, use ORDER BY with your SQL and then you just need a standard two-way match program, which is readily available on this forum.
Robert Sample
Global moderator
 
Posts: 3367
Joined: Sat Dec 19, 2009 8:32 pm
Location: Dubuque, Iowa, USA
Has thanked: 1 time
Been thanked: 222 times

Re: compare contents on two tables using a cobol program

Postby enrico-sorichetti » Mon Apr 29, 2013 9:49 pm

this is a professional forum,
STOP USING SMS JARGON/ABBREVIATIONS

and You will be entitled to smart replies only after You will have provided
the same amount of guidance the Nic and Robert have .

unfortunately Your attitude will earn You very little simpathy and even less help :geek:
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2644
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 130 times

Re: compare contents on two tables using a cobol program

Postby dick scherrer » Mon Apr 29, 2013 11:26 pm

Hello and welcome to the forum (maybe . . .),

i m looking for the solution not code.so first of all just see want i m asking before u reply
thanks for ur advice so u dont knw how it work


This is NOT a kiddie chat-room, so please do NOT post as you would there. Even though this is our forum for students and beginners, we expect people to post properly and show a good attitude.

The solution will surely be code. As you have not very clearly explained what you need to do (you may believe you were clear, but many will not understand what you really mean - and there is no need for people to guess). For one, i do not know what you want, so it will be better if you show what you "have" (both tables) and what you want to compare between them.

If is rather foolish to think someone "does not know" when they give a reply you didn't want. You need to consider the reply was to the post, not what you expected.

Hopefully, going forward your posts and attitude will improve.

d
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post