Search results for query: *

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

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

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...

Thanks!

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...

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!!

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.

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

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.

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

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.

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.

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.

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.

Thanks

Hi friends, I would like some information about Global Temporary tables in DB2 AS400. When and who drop this tables, and things like that. Thank u.

Hi friends, I have a question. Can I return a table in a db2 function or procedure? Please, can you write a small example? Thanks.

Hi friends, I am doing a .NET Windows application. I am working against a DB2 AS/400 database. I have some tables where i have put some key restrictions. I mean, for example i have 2 fiels in a table: name and address. The name i want to be unique. This restriction has a name, for example...

Hi friends, I am doing a .NET Windows application. I am working against a DB2 AS/400 database. I have some tables where i have put some key restrictions. I mean, for example i have 2 fiels in a table: name and address. The name i want to be unique. This restriction has a name, for example...

Hi, 'hour of the database db2' is current time of the operating system where DB2 runs on. So, how can i do? Thanks again