as400 crystal reports multi member files

Question

I am using crystal reports to read files on an as400, some of the files are multi-member files. how can i read a certain memeber without using the create alaisis command?

score 1 · Answer 1 · answered Jan 29 '13 at 18:28

1

SQL has no concept of a multi-member file. There is no special DB2 for i SQL extension that helps us handle multi-member files. Almost everyone who still uses multi-member files uses CREATE ALIAS.

If an alias doesn't work for your situation, call a stored procedure instead. The SP takes the member name, does the OVRDBF and creates an SQL result set that Crystal can then iterate over.

answered Jan 29 '13 at 18:28

Buck Calabro

7,558
22
25

can you please provide an example of how to use the create alias comand when i try it i get a cursor error ? thanks for your help – tony cuccaro Jan 31 '13 at 18:22
1

create alias buck.jan for prodlib.sales(jan2013) – Buck Calabro Jan 31 '13 at 18:31

score 1 · Answer 2 · edited May 23 '17 at 11:50

1

SQL has no concept of Multiple Members, so you need to use an ALIAS.

create alias MyLib.MyAlias for MyLib.MyLogicalFile(MyMember);

select * from MyLib.MyAlias;

drop alias MyLib.MyAlias;

Refer to:

edited May 23 '17 at 11:50

Community

1
1

answered May 13 '14 at 12:06

Christoff Erasmus

925
1
10
26

as400 crystal reports multi member files

2 Answers2