Domain name dropdown-list bx in subservice of the aps package

$xml = ‘<methodCall> <methodName>pem.getDomainList</methodName> <params> <param> <value> <struct> <member> <name>subscription_id</name> <value> <int>’.$subscriptionid.'</int> </value> </member> </struct> </value> </param> </params> </methodCall> ‘; you can use the following url for this. ‘http://’ . HOST . ‘:’ . PORT . ‘/’ . PATH;

How to limit the subservice creation in APS package?

In an APS package with one mainservice and one subservice. For example:Main service will fetch some basic credentials and subservice will create an account in the isp(using API). We can restrict this account creation using limit,means admin can limit the subservice-create account in the customer control panel. For implementing this we can use the following… Read More »

Difference between TRUNCATE,DELETE and DROP commands

1)DELETE-Delete command is using to remove a rows from a table. “Where” clause is used to remove some rows. if no “where” condition specified all rows will be removed. After performing a DELETE operation you need to “commit” or “Rollback” the transaction to make the change permanent or undo it. 2)TRUNCATE- “truncate” removes all rows… Read More »

Transaction Control-TCL

statements are used to manage the changes made by DML statements Some Examples 1)COMMIT-save work done 2)SAVEPOINT-identify a point in a transaction to which you can later roll back 3)ROLLBACK-restore database to original since the last COMMIT 4)SETTRANSACTION- Change transaction options like isolation level and what rollback segment to use.

Data Manipulation Language-DML

statements are used for managing data within the schema objects Examples as below 1.SELECT-retrieve data from the database 2.INSERT-insert data into a table 3.UPDATE-updates existing data within a table 4.DELETE-deletes all records from a table, the space for the records remain 5.MERGE-Upsert operation it will include both insert and update 6.CALL-call a PL/SQL or java… Read More »

Data Definition Language-DDL

These are used to define database structure or schema Examles as below 1.CREATE- create objects in the database 2.ALTER- alters the structure of the database 3.DROP-delete the objects from the database 4.TRUNCATE-remove all the records from the database  including spaces allocated for the records are removed. 5.COMMENT-add comments to the data dictionary 6.RENAME-rename an object.

For loops in shell scripting

Loops contains the code that will execute until the loop ends ———————————- Syntax: for arg in [list] do commands done ———————————- for arg in “$mydoubts1 $mydoubts2 “……”$mydoubts N” *) in pass 1 of the loop,arg=$mydoubts1 . . . 8) In pass N of the loop,arg= $mydoubts N For Loop Example #!/bin/bash # Listing the states… Read More »