× 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.


  1.  Home
  2. MIDRANGE-L
  3. October 2006

RE: Datalinks

Mike - sometimes it's better to be lucky than good!
I know our products can give you what you want - so this is a little vendor response - check out www.rjssoftware.com and look for Office Integrator and WebDocs iSeries Edition and the like. Or call one of our folks and tell them what you need.
Done with the commercial - there are other ways - you could simple store the path, then pass that to RUNPCCMD or whatever that is - I'm on vacation so have no memory - heh! Whatever you have, the green screen won't display it on its own, as you know. 

Good luck!
Vern

At 12:02 PM 10/16/2006, you wrote:


Vern, Good Guess.
I copied this one Insert statement into in interactive SQL session and
added the file://localhost prefix and ran the statement.  It added the
record.  Kewl.

Then I went to the source file changed all the records to include the
prefix.  Received error.

Performed a CLRPFM on EMPLOYEE.  Copied next statement to STRSQL, reran-
error.

Error 25 occurred using DataLink data type.
-- Error type 25 is file already linked.

Now I have to try and figure out how to remove the link and try again.

I'm not positive this is the best approach to my problem, but so far all
I have come up with is either the Datalink or a BLOB.  Initial thought
was to access these images from a green screen session, however I'm
fairly confident I can't do that(although not positive)

The request is to link images that relate to a particular service card
and have a user be able to see this image.
When the record is accessed.



Michael Smith
iSeries.mySeries.


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Vernon Hamberg
Sent: Monday, October 16, 2006 12:32 PM
To: Midrange Systems Technical Discussion
Subject: RE: Datalinks


Just a wild guess, Mike - the first parameter of DLVALUE is supposed
to be a URL, I believe - the docs at V5R2 says it needs to have a
scheme and server - try adding file://localhost in front maybe. I've
not done this, had no need to work with data links yet.

At 11:18 AM 10/16/2006, you wrote:

>Vern,
>First here is one of the sql statements.
>INSERT INTO EMPLOYEE VALUES
>   ( 104681, 'BARB', 'L', 'GIBBENS ', 898613,
>      DLVALUE( '/MYDATALINKS/EMPNOTES/BARBGIBBENS.TXT' ) );
>
>Here is some of the text from the joblog.
>  Message . . . . :  -RUNSQLSTM SRCFILE(DATALINK/QCLSRC)
>SRCMBR(POPEMPSQL)
>    COMMIT(*NONE)
>
>     10/16/06  08:37:54.881360  QDBSIGEX     QSYS        0D70
QSQRUN3
>QS
>  To module . . . . . . . . . :   QSQINS
>
>  To procedure  . . . . . . . :   SQL_Insert
>
>  Statement . . . . . . . . . :   9897
>
>  Message . . . . :   Data mapping error on member QSQPTABL.
>
>  Cause . . . . . :   A data mapping error occurred on field *N in
record
>number
>    1, record format QSQPTABL, member number 1, in member QSQPTABL file

>QSQPTABL
>    in library QSYS2, because of error code 28. The error codes and
>their
>
>    meanings follow: 26 -- For the CAST operation, a source character
>was found
>    that is not valid. 27 -- For the CAST operation, the character
>destination
>    field is too short to hold all the significant digits of the
>source. 28 --
>    User-defined function DLVALUE returned a mapping error. 29 -- Java
>
>
>    10/16/06  08:37:54.902880  QDBSIGEX     QSYS        01D6
QDBSIGEX
>QS
>Message . . . . :   Data mapping error on member QSQPTABL.
>
>Cause . . . . . :   A data mapping error occurred on member QSQPTABL
>file
>   QSQPTABL in library QSYS2, because the data fields in record number
>1,
>
>   record format FORMAT0002, member number 1 are in error. Recovery  .
>. . :
>    If the record number is zero, the error occurred on an attempt to
>put or
>    update a record through a logical file, or the error occurred on a
>group by
>    operation, or the error was caused by a default value, or the error

>was
>    caused by a null value in the record.  See previously listed
>message CPF5035
>    or CPD5036 to determine which fields are in error.  Change the
>fields that
>    are in error and try the operation again. If the record number is
>not zero,
>    the error occurred on an attempt to read an existing record from a
>file.
>    See previously listed message CPF5035 or CPD5036 to determine which

>physical
>    file fields are in error. Then either delete the record from the
>file or
>    change the data in the fields that are in error. Then try your
>request
>    again. Possible choices for replying to message . . . . . . . . . .

>. . . .
>
>  Message . . . . :   Error 21 occurred using DataLink data type.
>
>  Cause . . . . . :   An error occurred while using a DataLink.
Possible
>errors
>    are: -- Error type 21 is format of DataLink value not valid. --
>Error type
>    22 is the DataLink File Manager (DLFM) is not properly configured
>on the
>    server. -- Error type 23 is link type not valid. -- Error type 24
>is file
>    does not exist. -- Error type 25 is file already linked. -- Error
>type 26 is
>    file not available. -- Error type 27 is length of comment or URL
>not valid.
>
>
>There are 0 records in file Employee
>
>Michael Smith
>iSeries.mySeries.
>
>
>-----Original Message-----
>From: midrange-l-bounces@xxxxxxxxxxxx
>[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Vernon Hamberg
>Sent: Monday, October 16, 2006 9:10 AM
>To: Midrange Systems Technical Discussion
>Subject: Re: Datalinks
>
>
>There should be more information at second level - please post it.
>Easiest way to get it might be DSPJOBLOG OUTPUT(*PRINT) and copy-paste
>the relevant section.
>
>At 07:55 AM 10/16/2006, you wrote:
>
> >I'm trying to make use of Datalinks.  I am working through an article

> >in the IseriesNetwork from Jan of 01. " RPG IV "Crib Sheet" for SQL
> >DataLinks" I've gone through all the steps, however, when I run the
> >sql
>
> >statement to populate the datalinks I get the following error.
> >  Data mapping error on member QSQPTABL.
> >  Data mapping error on member QSQPTABL.
> >  Data mapping error on member QSQPTABL.
> >  Error 21 occurred using DataLink data type.
> >  RUNSQLSTM command failed.
> >  RUNSQLSTM command failed.
> >Error type 21 is format of DataLink value not valid.
> >
> >I have searched the archives and found some references to this, but I

> >haven't come across a solution.
> >
> >Anybody have an idea what is causing this and how to correct it?
> >
> >Thanks.
> >
> >
> >Michael Smith
> >iSeries.mySeries.
> >
> >--
> >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.
>
>--
>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.
>
>
>--
>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.

--
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.


--
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.

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.