string ls_select
string ls_where
string ls_dwsyntax
string ls_err
ls_select = &
"Select id, fname, lname, address, city, state, zip from customer"
ls_where = " where customer.fname like '" + is_cust + "%'"
ls_dwsyntax = SQLCA.SyntaxFromSQL ( ls_select, "Style(Type=grid)", ls_err )
dw_1.Create ( ls_dwsyntax, ls_err )
IF ls_err <> '' THEN
MessageBox ( "error - Syntax", ls_err )
ELSE
dw_1.SetTransObject ( SQLCA )
dw_1.Retrieve()
END IF
PowerBuilder........ PowerBuilder........ PowerBuilder........ PowerBuilder
Thursday, December 4, 2008
Create a table from PowerScript
Use EXECUTE IMMEDIATE. Set Autocommit to true because DDL SQL has to be executed outside of transaction.
SQLCA.AutoCommit = True
ls_sql = "create table #tmp (abc varchar(255))"
EXECUTE IMMEDIATE :LS_SQL USING SQLCA;
To alter a table, use the same idea:
ls_sql = 'ALTER TABLE dba.tbl_name ADD col_name'
EXECUTE IMMEDIATE :LS_SQL USING SQLCA;
SQLCA.AutoCommit = True
ls_sql = "create table #tmp (abc varchar(255))"
EXECUTE IMMEDIATE :LS_SQL USING SQLCA;
To alter a table, use the same idea:
ls_sql = 'ALTER TABLE dba.tbl_name ADD col_name'
EXECUTE IMMEDIATE :LS_SQL USING SQLCA;
Monday, December 1, 2008
Fast Track to PowerBuilder Part II
"Fast Track to PowerBuilder Part II"Now includes new features in PowerBuilder 11.5 !Dear PowerBuilder Developer:
DEV633: Fast Track to PowerBuilder Part II is perhaps the most important step you take in your training towards a level of expertise that will allow you to learn how to use PowerBuilder to build and deploy fully functional applications using its more advanced features. The course will be taught on PowerBuilder 11.5. However, most of the features you will learn will be available to you in earlier releases of PowerBuilder (for instance, PowerBuilder 9, 10 and 11) - so regardless of the release on which you are working, you will be able to continue to improve your skills by learning PowerBuilder development best practices for advanced client/server application development.
This intensive hands-on, instructor-led training class will give you access to a certified instructor, along with other near-expert level PowerBuilder client/server developers like yourself - whose goal is to learn PowerBuilder’s more advanced and powerful features. Register Now!
December 8, 2008 (Bethesda, MD)
December 8, 2008 (SyberLearning LIVE)
December 15, 2008 (Dublin, CA)
December 15, 2008 (Boulder, CO)
February 2, 2009 (SyberLearning LIVE)
Free : Norton AntiVirus 2009 Definitions Update (Windows XP 64-bit/Vista 64-bit)
Publisher's description of Norton AntiVirus 2009 Definitions Update (Windows XP 64-bit/Vista 64-bit)
From Symantec:
Download this file for the latest in virus detection and repair. This definitions update is a complete replacement for any previous virus definitions set and will work with the following Symantec products:
Norton AntiVirus 2008 for Windows XP/Vista for 64-bit OS only
Norton Internet Security 2008 for Windows XP/Vista for 64-bit OS only
Symantec Endpoint Protection 11.0 for 64-bit OS only
Download :
http://www.zdnetasia.com/downloads/pc/swinfo/0,39043052,39386086s,00.htm
From Symantec:
Download this file for the latest in virus detection and repair. This definitions update is a complete replacement for any previous virus definitions set and will work with the following Symantec products:
Norton AntiVirus 2008 for Windows XP/Vista for 64-bit OS only
Norton Internet Security 2008 for Windows XP/Vista for 64-bit OS only
Symantec Endpoint Protection 11.0 for 64-bit OS only
Download :
http://www.zdnetasia.com/downloads/pc/swinfo/0,39043052,39386086s,00.htm
Amazon opens up SimpleDB to the public
Amazon on Monday opened up its SimpleDB cloud-based database service to an unlimited beta audience, after a year's private testing.
SimpleDB is just one of many components that make up the Amazon Web Services (AWS) cloud-computing initiative--the others being the Simple Storage Service (S3) hosted storage facility, the CloudFront content-delivery service and the Elastic Compute Cloud (EC2) cloud-computing service. The opening up of SimpleDB to the public means anybody can use the service for real-time querying of the structured data hosted in AWS.
On the AWS blog on Monday, Amazon wrote that it had "learned a lot during the beta and [has] fine-tuned the feature set in order to make sure that we are meeting the needs of current and future users".
As Amazon writes on the SimpleDB web page, the service "provides a simple web-services interface to create and store multiple data sets, query your data easily and return the results". The company said that SimpleDB has similar properties to a spreadsheet, except for the ability to associate multiple values with each attribute of an item. Another feature that Amazon is touting is the ability to add new attributes to a SimpleDB set when this is necessary, rather than having to predefine every attribute.
SimpleDB is being presented as an alternative to complex databases. "Amazon SimpleDB removes the need to maintain a schema, while your attributes are automatically indexed to provide fast, real-time look-up and querying capabilities", the web page states. "This flexibility minimizes the performance tuning required as the demands for your data increase". However, complex databases can be hosted in EC2 if they are needed.
A "simple set" of application programming interfaces (APIs) is provided for the purposes of storing, processing and querying data.
As with other AWS services, the pricing of SimpleDB corresponds with usage, with no up-front costs being involved. Data transfer costs from US$0.10 (7 pence) per gigabyte in and out, although that only refers to data coming into and leaving SimpleDB from outside other AWS services--data transferred between SimpleDB and other AWS services is free.
Amazon recommends that large files and objects be stored in S3, with pointers and metadata associated with those files being stores in SimpleDB--the charge for this is US$1.50 per gigabyte per month.
As an extra incentive, those wishing to try out SimpleDB will be able to use it on a limited basis for free over the next six months at least. This will include the consumption of up to 500MB of storage and up to 25 machine hours of usage each month, plus 1GB of data in and 1GB out.
SimpleDB is just one of many components that make up the Amazon Web Services (AWS) cloud-computing initiative--the others being the Simple Storage Service (S3) hosted storage facility, the CloudFront content-delivery service and the Elastic Compute Cloud (EC2) cloud-computing service. The opening up of SimpleDB to the public means anybody can use the service for real-time querying of the structured data hosted in AWS.
On the AWS blog on Monday, Amazon wrote that it had "learned a lot during the beta and [has] fine-tuned the feature set in order to make sure that we are meeting the needs of current and future users".
As Amazon writes on the SimpleDB web page, the service "provides a simple web-services interface to create and store multiple data sets, query your data easily and return the results". The company said that SimpleDB has similar properties to a spreadsheet, except for the ability to associate multiple values with each attribute of an item. Another feature that Amazon is touting is the ability to add new attributes to a SimpleDB set when this is necessary, rather than having to predefine every attribute.
SimpleDB is being presented as an alternative to complex databases. "Amazon SimpleDB removes the need to maintain a schema, while your attributes are automatically indexed to provide fast, real-time look-up and querying capabilities", the web page states. "This flexibility minimizes the performance tuning required as the demands for your data increase". However, complex databases can be hosted in EC2 if they are needed.
A "simple set" of application programming interfaces (APIs) is provided for the purposes of storing, processing and querying data.
As with other AWS services, the pricing of SimpleDB corresponds with usage, with no up-front costs being involved. Data transfer costs from US$0.10 (7 pence) per gigabyte in and out, although that only refers to data coming into and leaving SimpleDB from outside other AWS services--data transferred between SimpleDB and other AWS services is free.
Amazon recommends that large files and objects be stored in S3, with pointers and metadata associated with those files being stores in SimpleDB--the charge for this is US$1.50 per gigabyte per month.
As an extra incentive, those wishing to try out SimpleDB will be able to use it on a limited basis for free over the next six months at least. This will include the consumption of up to 500MB of storage and up to 25 machine hours of usage each month, plus 1GB of data in and 1GB out.
Sun warns of 'fatal' bugs in MySQL 5.1
Sun has released version 5.1 of the open-source MySQL database software, but the software's founder simultaneously warned of a number of "fatal" bugs present in the new features that are still to be fixed.
Michael "Monty" Widenius, the founder of MySQL, stated
The new features introduced have been ranked as "beta" quality.
There are a number of issues associated with the partitioning feature, such as the difficulty to restore a partitioned table if it crashes, and the chance of losing all data in the event of a server crashing during the rename table feature of a partitioned table. Widenius highlighted that the feature was inefficient, particularly if there were many partitions in a database.
Row-based replication has not been enabled by default, because of a number of problems. Users are advised to test the latest MySQL version before deploying it to production systems.
Michael "Monty" Widenius, the founder of MySQL, stated
The new features introduced have been ranked as "beta" quality.
There are a number of issues associated with the partitioning feature, such as the difficulty to restore a partitioned table if it crashes, and the chance of losing all data in the event of a server crashing during the rename table feature of a partitioned table. Widenius highlighted that the feature was inefficient, particularly if there were many partitions in a database.
Row-based replication has not been enabled by default, because of a number of problems. Users are advised to test the latest MySQL version before deploying it to production systems.
Subscribe to:
Posts (Atom)
Custom Search