Process Mapping Logo

Process Mapping - Forums

Sharing 19 years of knowledge and experience

 
Metastorm BPM forums
Sign up Latest Topics
 
 
 


Reply
  Author   Comment  
hmayeu2

New Member
Registered:
Posts: 6
Reply with quote  #1 
Hi,

I am new to v9 and I am having issues pulling data from our DB2 connection.

In v7 I would be able to use the following code:
txtname:= %SelectSQL("select indiv_name from directory.name where id = '%originator'",DB2 connection info,etc, etc)

In v9 I am trying to use the expression builder to perform the same function.  Under variable I have selected :
NewProcess.txtName

Under Value I have built:
SelectSql(new DB2(),"SELECT DIRECTORY.NAME.INDIV_NAME  FROM DIRECTORY.NAME  WHERE ID = 'ProcessContext.FolderOriginator'")

This does not return any results.  I was curious if I am approaching this in the wrong way.

Any help would be appreciated.

Thanks




0
Jerome

Avatar / Picture

Guru
Registered:
Posts: 5,507
Reply with quote  #2 
Yes, you are. You are now a 'semi-colonist' as my brother puts it. That means you are now in the world of C#. You cannot do things the version 7 way any longer.

SelectSql(new DB2(),"SELECT DIRECTORY.NAME.INDIV_NAME  FROM DIRECTORY.NAME  WHERE ID = @Originator",SQLArg("@Originator", ProcessContext.FolderOriginator ))

Is the correct way.



__________________
Post an example, and we will have a much better idea what the problem is. In about 90% of posts, the problem is one of communication. Examples bridge that gap.
0
Jerome

Avatar / Picture

Guru
Registered:
Posts: 5,507
Reply with quote  #3 
We have a quick start tutorial that should get you familiar with the basic concepts, as well.

Written:
http://www.processmapping.com.au/freestuff/metastormbpm9quickstart/index.html

Video:
http://www.processmapping.com.au/freestuff/metastormbpm9quickstartvideo/index.html

and more possibly helpful stuff here:
http://www.processmapping.com.au/articles/MetastormBPMVersion9Review/MetastormBPMVersion9Review.html



__________________
Post an example, and we will have a much better idea what the problem is. In about 90% of posts, the problem is one of communication. Examples bridge that gap.
0
hmayeu2

New Member
Registered:
Posts: 6
Reply with quote  #4 
This worked perfectly!  Thanks for the help.

-Harry

0
Previous Topic | Next Topic
Print
Reply

Quick Navigation:


Create your own forum with Website Toolbox!