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!

Register Log in
  • Congratulations Chriss Miller 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 julen

  1. julen

    Atomic between DB2 and sqlServer

    Hi! I am doing a procedure in db2 as/400. And i am trying to call to sqlserver procedure. Is it possible? Thanks.
  2. julen

    Problem with iterate sentence

    Hi everybody!!! I am a programmer of db2/sql. Can anybody do a correct example of a FOR sentence using ITERATE sentence? Thanks.
  3. julen

    Problem with a query as400/db2

    Hi everybody, and thanks for reading my post. I have a problem when I do a query. This query has various inners. And when I executed the query, the navigator wait and wait, and doesn't show me rows. Sometimes I have to wait fifteen minutes or more and sometimes told me and error that says...
  4. julen

    prepared statement problem

    Thanks!
  5. julen

    prepared statement problem

    Hi everybody! I have a problem when i am trying to cast to a date in a prepared statement sentence. My sql sentence part is: || ' WHERE ' || ' CAST(CAST(YEAR( FH1)) AS VARCHAR(4))' || '-' || 'CAST (MONTH(FH1) AS VARCHAR(2))' || '-' || '01 AS DATE)' || ' >= CURRENT DATE ' And give me the...
  6. julen

    Debug a sql db2 code

    Hi! Thanks. My code is PL/SQL. What I mean, is that if it is an application/program that in a real time can debug/trace the code. Thanks again!!
  7. julen

    Debug a sql db2 code

    Hi everydoby!! Is it possible with an application/programm, point the exact line of error in my code. My sql db2 is for an as/400. Any ideas of different applications/Programms?? Thanks.
  8. julen

    Trace db2 sql code - Any Application?

    Hi MarcLodge!! I don´t know if I am clear. What I want to know is if it is possible with an application, point the exact line of error in my code. My sql db2 is for an as/400. Any ideas of different applications?? Thanks again
  9. julen

    Trace db2 sql code - Any Application?

    Hi everybody!!! I have been writing db2 sql code for two years, and now, I wonder if anyone knows if exists any programm or application to debug/trace easily this code. Can you help me? Thank you very much.
  10. julen

    DB2 add New Column in a specific position

    Yes, this is the way that i don't want to do. i mean a db2 sentence to insert it. Thanks
  11. julen

    DB2 add New Column in a specific position

    Hi, I have a DB2 AS400 database. Here, i have a table, with 3 columns: column1 columna columnb I want to insert a new column between column1 and columna. Is it posible with a db2 sentence?? Thanks.
  12. julen

    Problem with Performance 5VR4 and .NET applications

    Hi everybody, We have installed 5VR4 in a Web Server. And when we run .net applications the performance goes down. Nobody knows what can we do? Thanks.
  13. julen

    Arrays in DB2?

    Hi friends, I would like to know if there is any possibilities of using arrays in DB2 sql. Or is there any way of doing the same. Thanks again.
  14. julen

    NESTED FOR's help

    Hi everybody, How can I do this in sql DB2? FOR (i=0 to i< 10; i++) FOR (j=0 to j< 10; i++) .... Can you write me an example, please? Thank you.
  15. julen

    how can I return a Table in a function or procedure

    Thanks
See more

Part and Inventory Search

Back
Top