writing an sql statement from selecting records from two files using single statement and nested select statement.
No Answer is Posted For this Question
Be the First to Post Answer
why do we use readc? What is sflnxtchg?
is there any way I can ease my rpg controls on numeric input fields? How about an input date field?
How to debug a batch job when it is in messagewait(mswg) status. I know the steps for batch ebugging, but im confusing with when we submit any job for batch debug we put in held state. So here also do same thing or any other way?
how to get the particular field's records in CL without using OVRDBF,OPNQRY? tell me the concept?
how do you detect unused spool storage?
What is the purpose of SFLNXTCHG keyword in a subfile?
What is a message file?
Which command is used to replace CDUP command in FTP IF i WANT TO USE SFTP?
I need to insert a record in a file using STRSQL containing the some field values same as an already existing record in that file.I know to smple insert mentioning those values one by one.But is there any another query can be prepared for the same .Please share the query if known to you. Thanks in advance.
how to run other job when one job is active?
why we sometimes use same file name in FILE and TOFILE in OVRDBF and sometimes different??please tell
How can you identify End of file in CLP program?