developerWorks: Message List - IBM Data Studio

Developing DB2 9.7 modules in IBM Optim Development Studio 2.2

Wed, 25 Nov 2009 11:23:01 -0500

Hello

does anyone knows when will possible to develop DB2 9.7 modules in a Data Development Project in IBM Optim Development Studio?

Thanks in advanced

Re: Validation erros in DB2 9.7 store procedures with default parameters

Wed, 25 Nov 2009 09:23:38 -0500

It seems to be a problem when a default value is used. You can turn off syntax validation by right clicking on the editor window and unchecking the "validate syntax" item (though this is not advisable).

Validation erros in DB2 9.7 store procedures with default parameters

Wed, 25 Nov 2009 07:12:28 -0500

Hello
...

Re: IBM Data Studio and RAD 7.5.4

Tue, 24 Nov 2009 12:39:50 -0500

The IDA forum included a link to the RAD forum. Here's the direct link: http://www.ibm.com/developerworks/forums/forum.jspa?forumID=430&categoryID=24

Re: IBM Data Studio and RAD 7.5.4

Tue, 24 Nov 2009 12:06:31 -0500

Hi,
...

Re: IBM Data Studio and RAD 7.5.4

Tue, 24 Nov 2009 11:45:31 -0500

Is there any reason that this question is not being answered? Is there a better forum for RAD stuff? I had a quick look and I didn't notice one. Cheers.

Re: SQL Syntax Errors

Thu, 19 Nov 2009 16:32:42 -0500

I am unable to reproduce your error. I attached my screen shots.
Right-click > Run SQL on the DDL worked for me. However, I did notice that a parser exception was thrown.
I will open an internal defect for this.

Re: SQL Syntax Errors

Thu, 19 Nov 2009 15:45:11 -0500

Thanks. What I was trying to show is that the same SQL works fine if it's inside of a stored procedure. (I can now build it as a procedure in the SQL editor by setting the terminator to @ as you suggested.)
...

Re: SQL Syntax Errors

Thu, 19 Nov 2009 14:41:15 -0500

OK, I didn't realize you were using the Integrated Query Editor for SQL scripts. When I copied the statement into a SQL Script, I am able to reproduce your error. However, I found a sequence of actions that fixed the problems.
...

Re: SQL Syntax Errors

Thu, 19 Nov 2009 13:45:06 -0500

Thanks marichu. I tried removing the @ but still see the same syntax errors.
...