×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
On 23 May 2013 06:21, Crystal Reports wrote:
Using the STRSQLSTM
Source file . . . . Name
Library . . . . . *LIBL Name, *LIBL, *CURLIB
Source member . . . Name
Commitment control . *CHG *CHG, *UR, *CS, *ALL, *RS...
Naming . . . . . . . *SYS *SYS, *SQL
What do I put for my source file? I am trying to get away from the
DDS logical file.
As others have said, that may be RUNSQLSTM vs STRSQLSTM.? If so,
then note that if using the default of COMMIT(*CHG) [or anything other
than COMMIT(*NONE)], then be sure to include within the script, or after
the script completes, either the SQL request to COMMIT or the CL request
to COMMIT, respectively.
Name a Source Physical File Member [effectively a text file; a
database *FILE with attribute PF-SRC] which contains the SQL DDL to
create whatever will implement the necessary /objects/ to which the CR
reporting request will refer. There have been mentioned as
possibilities, among others, each of CREATE VIEW, CREATE PROCEDURE,
CREATE FUNCTION ... RETURNS TABLE (UDTF) as possible.
Given the reply was to my message that mimicked the poorly titled
message [but that was to keep in line with what the archive assigned for
the OP which apparently had been posted with an empty "Subject:"], i.e.
the message "Subject: [no subject]", I presume the question is
effectively about what one might code for a CREATE VIEW; thus:
create view aViewName as
( select
OHORDT, OHSHTC, OHORDD /* pbbly instead, _the_ list 5 fields */
from OEORHDOH
where OHORDD >= 20130101
AND OHSHTC <> ' '
)
; -- the semicolon is the statement separator
commit /* likely desirable, if using COMMIT(*CHG) */
; -- I normally place the ';' on its own line to be conspicuous
p.s. If either you do not care to take the effort\time to properly
reconstruct "Subject:" line, or you are not familiar with both how an
email list works generally and the effects of subject lines and proper
threading within the archives as provided by the archive.midrange.com,
then *please* subscribe to the individual messages instead of the
Digest-Mode; or use NNTP instead of email. Please look at the
not-so-threaded message subjects as started by or broken by "Crystal
Reports" in this month's archives; or just search the page for 'Digest'
without the apostrophes:
http://archive.midrange.com/midrange-l/201305
midrange.com
