Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by ryltech

  1. ryltech

    Create View on DB" problem

    Thanks everyone. From this I would gues it is something to do with the number of joins I am using. Just out of interest - this only happens when I attempt to create a view. If I run the select statement without the CREATE VIEW etc a the beginning it runs fine, but as soon as you attempt to...
  2. ryltech

    Create View on DB" problem

    Hello, I have created a view in DB2 which runs fine on my version of DB2 which runs on a windows machine. When i then try to run this same create view statement in iSeries (AS400) it comes back with the following error: [SQL0101] SQL statement too long or complex. The statement contains 4...

Part and Inventory Search

Back
Top