17 Feb When compiling SQLRPGLE source via CRTSQLRPGI, the SQL preprocessor includes the datasets containing variables for SQL execution. That implies to me, that if you want to use commitment control in SQLRPGLE, all files updated by the program must be journalled and all must. The module type will be RPGLE, only the source is SQLRPGLE. When you compile source that is SQLRPGLE it calls the SQL pre-processor.

Author: Disar Meztikree
Country: Saudi Arabia
Language: English (Spanish)
Genre: Life
Published (Last): 27 May 2006
Pages: 292
PDF File Size: 6.27 Mb
ePub File Size: 15.84 Mb
ISBN: 768-6-54791-522-5
Downloads: 5183
Price: Free* [*Free Regsitration Required]
Uploader: Zulugis

We’ll email you when relevant content is added and updated. JohnY Source sequence numbers are usually only useful for source manipulation. The fields must be in the same order in the SELECT as they are in the data structure, and the types must be compatible.

Ask a Question

This makes it very easy to move a column. Now we move on to the program. This was last published in September Althought it might seem a bit contrary, I’m going to use an internally described print file.

To keep it simple, I open the cursor then begin a fetch loop by fetching the data from the first row of the result set into the dsC1 data structure. Send me notifications when members answer or sqlrpvle to this question.

If batch, it shouldn’t matter. You could code it this way, adding another subfield to hold all the AddApp, UpdApp subfields: But this is just a hotfix for quick bug fixes as there are several hundreds of source files we may have to change and recompile.


With the exception of the status field, the cursor definition is pretty straightforward: The SrcId is listed on the right-hand side of the listing in the “Src Id” columns But for simple reports this method is usually perfectly sufficient.

Even on Interactive debug I’m getting line no, How can I get the statement number for the program. You forgot to provide an Email Address. You might not want an empty report, so you canmodify the code accordingly. This email address is already registered. I simply move it, making sure to move the corresponding column heading and dashes.

Post Your Answer Discard By clicking “Post Your Answer”, you acknowledge that you have read our updated terms of serviceprivacy policy and cookie policyand that your continued use of the website is subject to these policies. Please create a username to comment. If you have executable statements in copy files, you might have two different statements with the same number. Ask a question, help others, and get answers from the community. I wouldn’t expect that to work on any release; did it compile on an earlier release?

Stack Overflow works best with JavaScript enabled.

Rational Cafe:RPG Cafe:RPG Cafe:Problem when compiling an SQLRPGLE program – RPG Cafe Forum

xqlrpgle If any errors occur, the program auto-dumps and ends without halting. I agree to TechTarget’s Terms of UsePrivacy Policyand the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.


A look at hyper-convergence vs. Submit your e-mail address below. Just be aware that it’s possible that there will be multiple statements in your program with the same sqlrlgle number. Certainly we don’t expect behavior to get worse, but it happens. I match the dashes exactly in my detail line.

There is also an example of a derived field. What is a Tag? The program’s logic is very simple: No; some programs need attention when they bomb.

Does someone know what to do, or even where to have an eye on? Sign up using Facebook. Due to company lawment I cannot provide you specific source code, but the source code looks like this:. Your password has been sent to: RPG Cafe Log in to participate. Not exactly robust, but it works. Submit your e-mail address below. Because I force the heading this report will always print something even if no data is selected. You might want to investigate alternatives to water and fans to keep your data center cool.

It depends on whether or not this is an interact or batch application. Ben Rubenstein 11, pts.