Database integration (Queries Questions)

Unanswered Question
Apr 10th, 2007
User Badges:

Hello All!

We are using IPCC Express 4.0.4 at one of our customer place and we are struck at one place with fetching the data from database.

Customer is using Oracle database and one tables for employee details and they have three types of employees.

1) Contractors - Starts with X than 6 numeric eg X047813

2) Suppliers - Starts with S than 6 numeric numbers eg S047813

3) Regular employees - Contains six numeric numbers eg 047813

There is no uniqueness between the employee 6 Numeric numbers it can overlap following C and X. And as they have only one table which is handling all the information, its kinda difficult for us to figure our the way to do this.

The call flow would be.

Someone calls in at the main number and we ask to press 1 if you are Contractor, press 2 if you are Supplier and Press 3 if you are Regular Employee.

Or Press one if you are Supplier or Contractor and Press 2 for regular Employee. After press one submenu says Press 1 for Supplier and Press 2 for Contractor. and than 6 digit numeric value.

Question is how we can achieve this using limited functionalities of IPCC express with queries of database. How we can collect the Alphanumeric(X or C) and than numeric(6 digit) and than goto database with the complete information and query the database.

Or What we are thinking is to store X/C/nothing in one variable. and store the employee input in second variable.

But how to use these two variables in DB node in query?, if we dont give variables in DB node it works by defining the values in query but not otherwise.

OR is there any other way we can do this?

Pls Help!!

Thanks in Advance!


  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 4 (1 ratings)
mmelbourne Tue, 04/10/2007 - 02:25
User Badges:
  • Silver, 250 points or more

If Contractors always begin with an 'X' and Suppliers always begin with an 'S', and you are asking the caller whether they are Contractors, Suppliers or Regular Employees, then following these responses you should be able to prepend an 'X' or an 'S' to the 6-digit string, before you pass the string to the database query.

The Get Digit String will store the digits in a string variable. You can then use the "+" operator to concatenate the string. See attached code fragment which demonstrates the idea.

Please rate useful posts!

daljeetsingh1_2 Tue, 04/10/2007 - 21:19
User Badges:

Thanks for looking into this. We were able to do this similar way after posting it on Forum.


This Discussion