IBM Mainframe Forum

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

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.

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

i m looking for the solution not code.so first of all just see want i m asking before u reply

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

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.

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

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