×

Warning message

  • Cisco Support Forums is in Read Only mode while the site is being migrated.
  • Cisco Support Forums is in Read Only mode while the site is being migrated.

Write in DB

Unanswered Question
May 17th, 2006
User Badges:

Hello

I have IPCC premium.

I can write variable from script to table of SQL server.

I need to activate a application immediately after i was write a variable.

How can i activate a appplication with this variable.

For axample:

I need to activate "Notepade 123456".

The "123456" is a variable that write in SQL.


Thank you.


  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
sanjeev.thallik... Thu, 05/18/2006 - 05:17
User Badges:
  • Silver, 250 points or more

Where do you want to activate the application? what server or desktop?

shaul.cohen Thu, 05/18/2006 - 11:04
User Badges:

I want to activate the application on different server, with operation system 2003.

omendieta77 Fri, 05/19/2006 - 06:34
User Badges:

Hi,

Well I don't understand the scenario that you have.

This link is to enable the Database Subsystem.

http://www.cisco.com/en/US/partner/products/sw/custcosw/ps1846/products_administration_guide_chapter09186a008018e98d.html#1056609


Once it's enabled and you are connected to the database you can use the DB steps to get, write , read and release the database.

Anyway, pls describe your scenario.

Omendieta.

shaul.cohen Sat, 05/20/2006 - 21:27
User Badges:

Hello

I was success to write variable to DB, but i need to take this variable that write in DB and activate a application to Main Frame.

I need a trigger that activate this application when the script write in DB.


sanjeev.thallik... Sun, 05/21/2006 - 07:12
User Badges:
  • Silver, 250 points or more

Well, If you referring to Mainframe integration, then you need to look into Vonetix (Gold Systems) or Verastream (Attachmate). You cannot write directly to mainframe. You need to use java or http/xml to third party applications (mentioned above). The third-party applications will perform something called screenscraping to input and output data. This is the preferred method of integration to mainframe. There are some sql drivers that exist but not widely used. Don't know the names.

shaul.cohen Sun, 05/21/2006 - 10:00
User Badges:

Hello

I have the application that working with Main Frame.

I need a trigger that activate this application when i write a variable in DB from script.


sanjeev.thallik... Sun, 05/21/2006 - 13:56
User Badges:
  • Silver, 250 points or more

What type of application is this. Is this a java based application(.class, .jar) or can you call it through http request?

shaul.cohen Sun, 05/21/2006 - 21:47
User Badges:

It is application of Main Frame. it's call EntireX.

Do you know how can i trigger this application with java?

sanjeev.thallik... Mon, 05/22/2006 - 07:08
User Badges:
  • Silver, 250 points or more

Unless you know EntireX and what it supports, we will have no idea. Does EntireX has Java beans that you can use to open and close a mainframe session? Does it have java beans/apps to navigate to a certain mainframe screen and enter data and collect output? We don't know what EntireX. For all, it could just be a terminal emulator. You need to call EntireX or the people who know EntireX to give you more information.

JoeMattia Wed, 11/25/2009 - 07:56
User Badges:

Shaul,


would you happen to have a sample IVR script that I can review to see how to Read, Write and Relase an SQL DB?

Actions

This Discussion