Get answers.  Share knowledge.  Collaborate with peers.




RPG – Roll your own level breaks

stevensinstructionzone.com/BINF1310/07Chapter.ppt  This is a good review of control break processing it is not RPG specific but then the code you will be writing would be significantly the same in any language.    “Roll-your-own” is suppose is writing all the details like this powerpoint provides rather than using the old RPG II/III level controls. Phil



View Discussion   |  March 19, 2013  1:50 AM
AS/400, RPG, SQLRPGLE
discussed by:
philpl1jb
44,190 pts.

Encryption

Encryption of e-mail is rarely used by most general e-mail users. It’s not especially common even for business accounts. — Tom



View Discussion   |  March 19, 2013  1:35 AM
Encryption, Security, Security policies
discussed by:
TomLiotta
108,260 pts.

CLP Programming

it throws CPF4174 received by OVRRIDE2 at 209  error.
 
Of course it does. That’s what should happen for that program. You try to apply an override after you already opened the file.
 
Previous comments have said that you should not have OPNQRYF after you already ran RCVF. The same is true for OVRDBF. When RCVF runs, it causes the file to be opened automatically. Because the file is already open, it is too late to run OVRDBF.
 
There are other errors. For example, the DLTOVR immediately follows GOTO, and it doesn’t have a label. There is no way it can ever run.
 
Don’t do OVRDBF or OPNQRYF after RCVF for the same file.
 
Tom



View Discussion   |  March 19, 2013  12:42 AM
CL programming, CLP
discussed by:
TomLiotta
108,260 pts.

What does 404/home mean?

It’s not clear what “BT” is nor what “Infinity” is. And it’s not clear what either of those have to do with the question. But if you’re going to have any responsibility for a HTTP server, you should study HTTP first. In this case, you should study the Status Code Definitions. — Tom



View Discussion   |  March 19, 2013  12:32 AM
404 query, HTTP
discussed by:
TomLiotta
108,260 pts.

CLP Programming

Typically the OpnQryF is used to control downsteam programs.
Trying to affect a program that has an file already open ?? doesn’t seem possible.
As far as your code goes .. if it were to work, you must dlt the override and close the file every loop. 
 
  I’m a little off today on the “”"” quotes in the query select.



View Discussion   |  March 18, 2013  6:34 PM
CL programming, CLP
discussed by:
philpl1jb
44,190 pts.

Switch IP

plizz – packet capture will not see any packets from the the switch itself, unless it is a L3 switch, as it is not sending any packets out with it’s own IP, it just forwards them from other devices. If the switch is in the same subnet as the PC, you could try to ping every address in the subnet, and see if the mac address of any replies matches the one on the label of the switch (most switches have this label). If not then you need to do the password recovery on the switch, basically as Tom was expalining.



View Discussion   |  March 18, 2013  5:04 PM
IP address, IP address management
discussed by:
BlankReg
12,265 pts.

Accessing the call center

There is no question here. 

If you need us to help you, please let us know what the problem is, and provide enough details about the problem and the environment.



View Discussion   |  March 18, 2013  2:38 PM
Avaya, Call Center
discussed by:
carlosdl
63,535 pts.

Crystal Reports: Sum by certain date

That’s good. 

How can we help?



View Discussion   |  March 18, 2013  2:35 PM
Crystal Reports, Crystal Reports formulas
discussed by:
carlosdl
63,535 pts.

Switch IP

You can use wireshark to capture ethernet packet for your network interface card. Check capture data and you willl see the ip address of the switch.Good luck.



View Discussion   |  March 18, 2013  1:40 PM
IP address, IP address management
discussed by:
plizz
100 pts.

CLP Programming

it throws CPF4174 received by OVRRIDE2 at 209  error.
 



View Discussion   |  March 18, 2013  1:34 PM
CL programming, CLP
discussed by:
jainamit
380 pts.

CLP Programming

PGM
DCLF FILE(AMITLIB/STUDPF)
DCL VAR(&VAR1) TYPE(*DEC) LEN(6) VALUE(672419)
LOOP: RCVF RCDFMT(STUDRRC)
MONMSG MSGID(CPF0864) EXEC(GOTO CMDLBL(END))
SNDUSRMSG MSG(&NAME)
OVRDBF FILE(STUDPF) TOFILE(AMITLIB/STUDPF) +
MBR(*FIRST) SHARE(*YES)
OPNQRYF FILE((STUDPF)) QRYSLT(‘(ID *GT “672419″)’) +
KEYFLD(*FILE)
CPYFRMQRYF FROMOPNID(STUDPF) TOFILE(AMITLIB/STUDPF1) +
MBROPT(*ADD) FMTOPT(*NOCHK)
GOTO CMDLBL(LOOP)
DLTOVR FILE(STUDPF)
CLOF OPNID(MYFILE)
END: ENDPGM



View Discussion   |  March 18, 2013  1:32 PM
CL programming, CLP
discussed by:
jainamit
380 pts.

CLP Programming

what is wrong in this code..??



View Discussion   |  March 18, 2013  1:31 PM
CL programming, CLP
discussed by:
jainamit
380 pts.

Embedding linked Excel into PDF

Or are you asking about an Excel file that current Adobe Acrobat releases can ‘attach’ to a .PDF (also by a “link”)? In that case, the Excel file does carry along with the rest of the ,PDF. But it’s not clear what you’re asking about for a second Excel file. Is it just a question of attaching two Excel files to a single .PDF?– Tom



View Discussion   |  March 18, 2013  12:52 PM
Microsoft Excel, PDF
discussed by:
TomLiotta
108,260 pts.

Embedding linked Excel into PDF

Excel files aren’t embedded in .PDFs. The printed output from Excel gets embedded. The printed output is not an Excel file; it’s just printed output. Now, you can embed a link in a .PDF that will open Excel; but that might not be quite what you’re asking about. In that sense, you could embed two links to two Excel files. The Excel files themselves would not be “in” the .PDF. — Tom



View Discussion   |  March 18, 2013  12:42 PM
Microsoft Excel, PDF
discussed by:
TomLiotta
108,260 pts.

ALCOBJ on a Data area

The ALCOBJ needs to be part of the submitted job while it runs, not part of the job that runs SBMJOB. If the ALCOBJ fails, the submitted job should end itself. — Tom



View Discussion   |  March 18, 2013  12:22 PM
Allocate Object, AS400 Command, Data Area
discussed by:
TomLiotta
108,260 pts.

About AS/400

First thing you should do is put meaningful subjects on your questions. “About AS/400″ is not helpful for other members who look for answers or for subjects they are familiar with.
 
…I run the program by taking the option ‘c’ in the object library,…
 
What does that mean? Where do you put “option ‘c’”?
 
Now I included two object libraries to my library list…
 
How did you do that? What library list did you put it into? How are you determining *your* library list?
 
CPF4160 means that there is no program of that name in the library that was specified on the CALL command. If no library was specified, then there is no program of that name in any library in the job’s library list. If the library list was used, it could also mean that there is insufficient authority to use that program.
 
Tom



View Discussion   |  March 18, 2013  12:16 PM
AS/400, AS/400 error messages
discussed by:
TomLiotta
108,260 pts.

CLP Programming

Now, if your RCVF loop comes after the OPNQRYF, what do you get? It’s possible to do it by using RCVF after OPNQRYF. But usually a CL program would simply use RCVF in a loop without OPNQRYF. You’d just have an IF command inside the loop to test for the record you want to display. — Tom



View Discussion   |  March 18, 2013  12:01 PM
CL programming, CLP
discussed by:
TomLiotta
108,260 pts.

File Status 90 during open

Thanks Tom , problem solved —It was happening only in debug , coz Update production file was not set to *YES 



View Discussion   |  March 18, 2013  12:00 PM
AS/400, COBOL
discussed by:
asakla
225 pts.

CLP Programming

OVRDBF     FILE(STUDPF) TOFILE(AMITLIB/STUDPF) +                     MBR(*FIRST) SHARE(*YES)                    OPNQRYF    FILE((AMITLIB/STUDPF)) QRYSLT(”’id *ge “” +             *cat &var *cat”””’)                     



View Discussion   |  March 18, 2013  11:55 AM
CL programming, CLP
discussed by:
jainamit
380 pts.

CLP Programming

this is what i tried
 



View Discussion   |  March 18, 2013  11:54 AM
CL programming, CLP
discussed by:
jainamit
380 pts.