or pls go to your motherboard website and find your motherboard and download the driver required. if you are using win 7 then they can find the driver automatically from windows update

If Hibernate doesn’t use journalling, then you can set it up any way you want. If Hibernate doesn’t use it, then it doesn’t “require” any setting at all. I’d certainly set it up for BOTH, but it’s your choice. — Tom

Hi TomLiotta,
Hibernate can be used with or without journalling with DB2/400 as database.
Our case is with journalling, Does it requires  AFTER or BOTH images when we do STRJRNPF for the file.Since BOTH images is costly with respect to database.Can AFTER image alone is enough when we use Hibernate?
Thanks,
Amutha

Yeah, it’s tricky when reviewing questions that are updated. I’m also not sure where the UPDATE line in the  came from. Very possibly, it was a line that I failed to replace when I pasted into a temporary Notepad doc I was using.
 
But if “SQL statement not allowed” was original error text, then the ‘Answer’ is almost certainly correct. A SELECT statement is not meaningful as a RUNSQLSTM statement.
 
Tom

…to fetch the header information what values i need to pass in  the start variable and Length variable ?
 
I don’t know what values you want. It depends on where you want to start in the headers and how much of the headers you want to retrieve.
 
The link I gave diagrams possible ares that you might need or be interested in. Offsets are shown.
 
You can use the QUSPTRUS API to retrieve a pointer to the space. The offsets to the pointer address are shown in the diagram.
 
If you don’t want to use QUSPTRUS, you can use the QUSRTVUS API, as you showed. Instead of an offset for a pointer, you use the position to start your retrieval.
 
Offsets use a zero base for the start of the space. Positions use (1) as the start of the space. You used QUSRTVUS, so you would take an offset value from the diagram and add (1) to it for the position. The position is the “starting value”.
 
But I don’t know where you want to start. Try different starting positions and lengths, retrieve some values and look at them. Compare what you retrieve to the format definitions in the documentation. That’s how you will learn.
 
Tom

But that update doesn’t make much sense (at least to me), unless it is a separate statement.  Could it be that Tom was testing something else, and included that line here by mistake? (not likely, I know).

FTP yourAS400USRPRF  PasswordBINPUT fromloc  tolocQUIT 

Welcome to ITKE, Razzak! Gravure is a type of printing method when an image is applied to substrate by the use of a metal plate. To learn more about its functions, check out this great description from WhatIs.com.

I am not aware of using BINARY while doing PUT. Some could give brief on this

It sound like you have problem with DHCP release/renew IP address to client. Before you join the domain find out what is your IP address, Gateway, DNS, DHCP. Try to ping the DNS server and Domain Controller. Is your Domain Controller host DHCP?

Right I listed the SQL code as it appeared originally .. at that time it included an error statement but no  
UPDATE TSTSQL/TSTTBL SET NAMECOL = ‘THIRD’ WHERE IDCOL = 3
Edited twice is suspect .. once adding the update and subsequently removing it.
 
 

The AP access points if that is the case may be for hand-held barcode scanners like we use here. Give us a little more info on what the request given to you was if you can. 

Old school way was to print line again with no spacing. If you have an actual PRTF for your specs you could try an see if the font can be changed.That may only work if you are printing forms.  What type of printer are you using? Is there a interface to generate forms like OPTIO?

If the user signs off and signs on and runs the second logic without running the first, do they get this error?
Phil

A stored procedure is a good way of creating re-usable code
across multiple platforms. We have some RPG programs that we used to create some stored procedures. We can now use these in our web applications as well as the corporate green screen code. It only needs to be maintained in one place which keeps things in sync.

Thanks. My professor advised me that with the IIF that we only need ” ” around text statements and not around values and other things. I’ll try out the rest and see what happens. Thanks for your help.

Perhaps like this …  
 
 IIF([Waiver] = “Yes”, IIF([Academic] = “Yes”, “Approved”, “Not Approved”),”Not Approved”)  
 
You need quotes around the “Yes” and () around the functions 

Look at each of your IIF function calls separately.  Each one should be used this way:

IIF(<condition>,<value if true>,<value if false)

Your inner IIF call doesn’t even include paranthesis, and it is not clear whether the “Approved” and “Not Approved” values are part of the inner or the outer function call.

I seriously recommend trying to understand how the IIF function works  before trying other options in your query.  Once you understand that, you will write your query easily. 

The link Phil suggested could help you on that. 

Good luck.

No. I’m not copy and pasting the code. It’s accepting the code and not giving me an error message that it’s missing information. What is incomplete with the code?

Are you copy-pasting your code? 

I don’t see how that code could even be accepted by Access, since it is incomplete.