SQL/400 : a professional programmer's guide

著者

• Martyn, Tim
• Hartley, Tim
• Johnson, Richard

書誌事項

SQL/400 : a professional programmer's guide

Tim Martyn, Tim Hartley, Richard Johnson

（J. Ranade IBM series）

McGraw-Hill, c1995

注記

Includes index

内容説明・目次

内容説明

This practical guide to SQL focuses on data retrieval and manipulation using the powerful AS/400 dialect. In a tutorial format, the authors cover a wide range of SQL material, including selecting data from a single table, using built-in functions, defining and manipulating data and accessing multiple tables. The book is full of information on SQL/400, including database security and transaction processing, and it explores AS/400 catalogue.

目次

• Part 1 Selecting data from a single table: the select statement
• sorting the "result" table
• Boolean connectors - and-or-not
• pattern matching
• arithmetic expressions. Part 2 Built-in functions: column functions
• scalar functions. Part 3 Data definition and manipulation: data definition
• data manipulation
• processing null values. Part 4 Accessing multiple tables: the join operation
• UNION
• subqueries
• correlated subqueries. Part 5 More about SQL/400: the view concept
• database security
• transaction processing
• exploring the AS/400 catalogue
• appendices.

「Nielsen BookData」 より

詳細情報

• NII書誌ID(NCID): BA25560552
• ISBN:
  • 0070407991
• LCCN: 94038608
• 出版国コード: us
• タイトル言語コード: eng
• 本文言語コード: eng
• 出版地: New York ; Tokyo
• ページ数/冊数: xix, 499 p.
• 大きさ: 25 cm
• 分類:
  • LCC : QA76.8.I25919
  • DC20 : 005.75/65
• 件名:
  • LCSH : IBM AS/400 (Computer) -- Programming
  • LCSH : SQL (Computer program language)
  • LCSH : Database management
  • LCSH : Relational databases
• 親書誌ID:
  • BA07710890