Write in DB

[shaul.cohen]

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.

[sanjeev.thallikar]

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

[shaul.cohen]

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

[omendieta77]

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]

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

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]

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

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

[shaul.cohen]

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

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

[sanjeev.thallikar]

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]

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?