General discussion
April 26, 2002 at 07:28 PM
jppk2

AS400 SQL – how to select a member

by jppk2 . Updated 24 years, 4 months ago

I may try to delete records from an AS400 DB2 physical file, which has 10 members. I only want to delete records from member number 10, but my script only reads the first member in the file.

I have tried the following combinations of brackets and spaces and dots between the file name and memebert name etc. But none of it works

delete from lib/file (member) where chdrnum = ‘50146382’

This discussion is locked

All Comments