Re: View to create a PF?

Rob:
Input
parameters

File . . . . . . . . . . . . . . . . . . . :
ACBALMPK
Library . . . . . . . . . . . . . . . . . :
ASTCCDTA
File
Information

File . . . . . . . . . . . . . . . . . . . :
ACBALMPK
Library . . . . . . . . . . . . . . . . . :
ASTCCDTA
File location . . . . . . . . . . . . . . . :
*LCL
Externally described . . . . . . . . . . . :
Yes
Number of record formats . . . . . . . . . :
1
Type of file . . . . . . . . . . . . . . . :
Logical
SQL file type . . . . . . . . . . . . . . . :
VIEW
File creation date . . . . . . . . . . . . :
08/23/13
Record Format
Information

Record format . . . . . . . . . . . . . . . :
ACBALMPK
Format level identifier . . . . . . . . . . :
38D8DD6B7D2D0
Number of fields . . . . . . . . . . . . . :
14
Record length . . . . . . . . . . . . . . . :
115
Format text . . . . . . . . . . . . . . . . : FORMAT0001
Field Level
Information

Data Field Buffer Buffer Field
Column
Field Type Length Length Position Usage
Heading
LMLTPC CHAR 3 5 1 Input
WWLTPC
Field text . . . . . . . . . . . . . . . : LOCATION TYPE
CODE
Variable length
field

Renamed field . . . . . . . . . . . . . . :
*VIEWF0001
Coded Character Set Identifier . . . . . :
65535
IRLOC1 CHAR 6 8 6 Input
IRLOC1
Variable length
field

Coded Character Set Identifier . . . . . :
65535
Derived field text . . . . . . . . . . .
:
COALESCE ( IRLOC1 , ''
)
IRLOC2 CHAR 6 8 14 Input
IRLOC2
Variable length
field

Coded Character Set Identifier . . . . . :
65535
Derived field text . . . . . . . . . . .
:
COALESCE ( IRLOC2 , ''
)
IRLOC3 CHAR 6 8 22 Input
IRLOC3
Variable length
field
Coded Character Set Identifier . . . . . :
65535
Derived field text . . . . . . . . . . .
:
COALESCE ( IRLOC3 , ''
)
IRPRT# CHAR 15 17 30 Input PART
NO.
Field text . . . . . . . . . . . . . . . : PART
NUMBER
Variable length
field
Allows the null
value
Renamed field . . . . . . . . . . . . . . :
*VIEWF0008
Coded Character Set Identifier . . . . . :
65535
Data Field Buffer Buffer Field
Column
Field Type Length Length Position Usage
Heading
IRQOH# PACKED 13 2 7 47 Input
QUANTITY

ON-HAND
Field text . . . . . . . . . . . . . . . : QUANTITY
(ON-HAND)
Allows the null
value
Renamed field . . . . . . . . . . . . . . :
*VIEWF0009
Data Field Buffer Buffer Field
Column
Field Type Length Length Position Usage
Heading
IRWHS# CHAR 3 5 54 Input
WWWHS#
Field text . . . . . . . . . . . . . . . : WAREHOUSE
NUMBER
Variable length
field
Allows the null
value
Renamed field . . . . . . . . . . . . . . :
*VIEWF0010
Coded Character Set Identifier . . . . . :
65535
Data Field Buffer Buffer Field
Column
Field Type Length Length Position Usage
Heading
IEPRT# CHAR 15 17 59 Input
IEPRT#
Variable length
field
Coded Character Set Identifier . . . . . :
65535
IEQOH# PACKED 13 2 7 76 Input
IEQOH#
Derived field text . . . . . . . . . . .
:

.00
IELOC1 CHAR 6 8 83 Input
IELOC1
Variable length
field
Coded Character Set Identifier . . . . . :
65535
IELOC2 CHAR 6 8 91 Input
IELOC2
Variable length
field
Coded Character Set Identifier . . . . . :
65535
IELOC3 CHAR 6 8 99 Input
IELOC3
Variable length
field
Coded Character Set Identifier . . . . . :
65535
IERIDC CHAR 2 4 107 Input
IERIDC
Variable length
field
Coded Character Set Identifier . . . . . :
65535
IEWHS# CHAR 3 5 111 Input
IEWHS#
Variable length
field
Coded Character Set Identifier . . . . . :
65535





On Fri, Aug 23, 2013 at 12:50 PM, <rob@xxxxxxxxx> wrote:

Can you paste the results of DSPFFD against the view? I have some
suspicions but I want to keep them to myself until I see this.


Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1
Group Dekko
Dept 1600
Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: Hoteltravelfundotcom <hoteltravelfun@xxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>,
Date: 08/23/2013 12:40 PM
Subject: Re: View to create a PF?
Sent by: midrange-l-bounces@xxxxxxxxxxxx



the users who like myself just run the CR are fine once I had changed the
ODBC Admin and check the translate box there for CCSID. Before that it
would display HEX data. Now it is fine.
THe problem is for users who connect via the Business Objects server which
is web based. Even tho we changed the Translate the same check box on the
server, it still gives this message:
"The Viewer cannot process an event. Error in file inventory detail
report.
Failed to retrieve data from the database. Details (Database Vendor Code
:-
551 Error Code CRWEB000000119)

And this only happens to a View created Logical. If its a plain DDS
created
PF or LF you don't have this issue.


On Fri, Aug 23, 2013 at 11:56 AM, Buck Calabro <kc2hiz@xxxxxxxxx> wrote:

On 8/23/2013 11:49 AM, Hoteltravelfundotcom wrote:

CHAR (6) is fine.
How do you code numeric like CAST(IRQOH# AS NUMERIC(13.2)

In your Crystal Report, are the numbers funny looking, or only the
characters?
--buck

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