Re: STRPCCMD command to open a URL from Client Access Session

["Karl Abbott" <karl@xxxxxxxxxx>]

Sorry, that was a type-o. The interactive request was actually 
file:\\ iseries\root\folder\helptext.html#bmark

> You are aware that you have "#bookmark" in the interactive string and
> "#bmark" in the CLP, right? I'd expect it to position to the top if
> there is not matching bookmark in the document.
>
> - -- 
> Pete Hall
> pete@xxxxxxxxxxxxxx
>
> On 2010-11-19 17:18, Karl Abbott wrote:
> > I want to put the help text for my application into an HTML page and
> > store it on the IFS. 
> >
> > The HTML will contain anchor tags (bookmarks) that allow positioning
the
> > user at the appropriate section of the help text.
> >
> >  
> >
> > If I go into a browser and type
> > file:\\iseries\root\folder\helptext.html#bookmark
> > <file:///\\iseries\root\folder\helptext.html#bookmark>  it works
> > perfectly.
> >
> > But when I put this into a CL program using the following code it
strips
> > off the #bmark, which means it always positions to the top of the
page.
> > PGM 
> > DCL        VAR(&CMD) TYPE(*CHAR) LEN(98)
> > DCL        VAR(&path) TYPE(*CHAR) LEN(50)
> >
> > STRPCO     PCTA(*NO)
> > monmsg     cpf0000
> > chgvar var(&path)
> > value('file:\\iseries\root\folder\helptext.html#bmark')           
> >
> > chgvar var(&cmd) value('rundll32 url.dll,FileProtocolHandler ' *bcat
> > &path) 
> >
> > STRPCCMD   PCCMD(&cmd) pause(*no)
> >
> > ENDPGM
> >
> > Any suggestions?
> > Thanks, Karl

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)

iEYEARECAAYFAkzoSvEACgkQXczQcKdXKg630QCeJ8nAlh8wE219d7luc2/WAAbK
RI0An0FOpkmYWdGtnB1d6NOvKcrGncwX
=xd2o
-----END PGP SIGNATURE-----


------------------------------

message: 3
date: Sat, 20 Nov 2010 23:27:36 -0600
from: Scott Klement <midrange-l@xxxxxxxxxxxxxxxx>
subject: Re: STRPCCMD command to open a URL from Client Access Session

Have you tried ShellExec?  It might be worth a try.

On 11/19/2010 5:18 PM, Karl Abbott wrote:
> I want to put the help text for my application into an HTML page and
> store it on the IFS.
>
> The HTML will contain anchor tags (bookmarks) that allow positioning
the
> user at the appropriate section of the help text.
>
>
>
> If I go into a browser and type
> file:\\iseries\root\folder\helptext.html#bookmark
> <file:///\\iseries\root\folder\helptext.html#bookmark>   it works
> perfectly.
>
> But when I put this into a CL program using the following code it
strips
> off the #bmark, which means it always positions to the top of the
page.
> PGM
>
>
> DCL        VAR(&CMD) TYPE(*CHAR) LEN(98)
>
>
> DCL        VAR(&path) TYPE(*CHAR) LEN(50)
>
>
>
>
>
> STRPCO     PCTA(*NO)
>
>
> monmsg     cpf0000
>
>
> chgvar var(&path)
> value('file:\\iseries\root\folder\helptext.html#bmark')
>
> chgvar var(&cmd) value('rundll32 url.dll,FileProtocolHandler ' *bcat
> &path)
>
> STRPCCMD   PCCMD(&cmd) pause(*no)
>
>
>
>
>
> ENDPGM
>
>
>
>
> Any suggestions?
>
> Thanks, Karl



------------------------------

message: 4
date: Sun, 21 Nov 2010 08:43:52 +0100
from: <dieter.bender@xxxxxxxxxxxx>
subject: Re: time/date as key fields

... maybe I don't use left outer joins from a parent with its child (why

should one do this) and so I've had no chance to recognize the effects
of 
this feature.
BTW: I'm using RI constraints, wherever possible and allowed by my 
custumors; in most cases they don't wanna use them...

--------------------------------------------------
From: "CRPence" <CRPbottle@xxxxxxxxx>
Sent: Saturday, November 20, 2010 9:51 PM
Newsgroups: midrange.midrange-l
To: <midrange-l@xxxxxxxxxxxx>
Subject: Re: time/date as key fields

> On 11/20/10 7:23 AM, dieter.bender@xxxxxxxxxxxx wrote:
> > ... seems to be pure marketing to me, I didn't find any
> > documentation, how it works and about measurable benefits...
> >
> > Birgitta Hauser wrote on Saturday, November 20, 2010 3:24 PM:
> > > What about "constraint awareness", a technology that checks
> > > constraints and handles them in a special way?
> > > Check constraint awareness and RI awareness were both introduced
> > > within the SQE in Release V5R3M0.
>
>   The DB2 SQL for i [the SQE] does utilize information from
constraints
> for making some decisions.  There had even been a defect, early-on,
> whereby an error in implementation effected incorrect output for
having
> omitted rows for values which were actually in the database.
>
>   For example, the database can implicitly know that a value that is
> not in the parent will not be in the child, and can optimize the
access
> plan and path for data retrieval with that understanding.  That
specific
> utilization of constraint awareness was the source of the
aforementioned
> defect, though I do not recall the details [perhaps applying rules
from
> a constraint that was not enforced per CHGPFCST STATE(*DISABLED) or in
> CHECK PENDING status].  Similarly, logic in a check constraint can
> eliminate selection rules, probes, and actual retrieval of data that
> "can not exist" according to the rules.  Note that such logic makes
> little sense with regard to the TABLE [on which the constraints are
> defined] for the latter two, since the physical data is just not there
> [else there is a highly negative defect]; the logic applied from
> constraints definitely assists for improvements on [implementations
> effected as or similar to] join logic.  If you have many values 'X' in
a
> column used to join on a column in a child file whose parent has no
> value 'X', then there is no need to inquire of any INDEX on the child
if
> there are any rows with the value 'X'; i.e. there must not be any
> 'X'-rows in the child, thus do not perform any actions that might
> otherwise lead down the path to locate any such rows.
>
> -- 
> Regards, Chuck
> -- 
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

> list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.


------------------------------

message: 5
date: Sun, 21 Nov 2010 06:50:58 -0600
from: "Don Cavaiani" <dcavaiani@xxxxxxxxxxxxx>
subject: Out of luck?

I am 2 hours from the office, and I made a database change yesterday
which must have caused an overnight job to error.  Now, qinter is off,
and I can't access system from home.  The system is running and I can
access http servers - but nothing else.  Is there any way out?


------------------------------

message: 6
date: Sun, 21 Nov 2010 07:10:52 -0600
from: "Don Cavaiani" <dcavaiani@xxxxxxxxxxxxx>
subject: Out of luck?

Sorry to bother - job must have finished, and I can get back on now!
 
 
 
I am 2 hours from the office, and I made a database change yesterday
which must have caused an overnight job to error.  Now, qinter is off,
and I can't access system from home.  The system is running and I can
access http servers - but nothing else.  Is there any way out?


------------------------------

message: 7
date: Sun, 21 Nov 2010 07:41:59 -0600
from: "Laine, Rogers" <rlaine@xxxxxxxxxxxxxxx>
subject: RE: Out of luck?

Don,

Do have a 5250 session setup for port 2300 with userid of Q#HMC that
connects to the HMC.                    This session runs under QCTL.

Rogers

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Don Cavaiani
Sent: Sunday, November 21, 2010 6:51 AM
To: Midrange Systems Technical Discussion
Subject: Out of luck?

I am 2 hours from the office, and I made a database change yesterday
which must have caused an overnight job to error.  Now, qinter is off,
and I can't access system from home.  The system is running and I can
access http servers - but nothing else.  Is there any way out?