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

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

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.

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 friends, I would like some ideas of how can i do that. I have a .NET windows application. This application, has a logon window. When I logon, the application go to DB2 database and get the db2 timestamp. I set this timestamp into a variable of .NET which I use it for different things...

Hi friends, I have a problem. I want to know if it is possible to have a type of data in db2 that can stored something like that: Hello (write in black) world (write in italic (cursive)) I mean, store a rich text. Thanks.

Hi! I have a problem. I have some strange characters in a string and I want to replace them. My version of O/S is the 5.2 and I don't have the sentence 'replace', so i have to do it reading each character and comparing them. If they are the same, changing them with a blank. How can I do...