webservices overview

XML:

NMTOKENS . A single word; otherwise a list of them separated by whitespace. (e.g, “hello world” is invalid where as “hello” is valid)

WSDL:

WSDL document essentially has four parts

definition

• message

  • part ^name ^type

• portType

  • Operation

    • input *

    • output

• binding

  • ^name ^type (portType)

  • soap | http

  • <soap

    • operation

      • input

        • soap:body use=”encoded|literal”

      • output

        • soap:body use=”encoded|literal”

• service

  • ^name

  • documentation

  • port ^name ^binding

    • soap:address location=” http://a/b.wsdl”

Build materials

Combine all SQL scripts from CVS links into one

I was asked to create a single SQL script from a document that has cvs links for each sql. Here is what I did,

1. Download DAP a.ka. Download accelerator
2. Copy all the CVS links into a text file
3. Replace "&view=markup" and "&view=auto" with blanks
4. Open Download accelerator and import the text file (File -> Import -> Plan text file)
5. Download all
6. exeute dos2unix command in downloaded directory
   
7. execute this command in unix (or cygwin for windows)
   find . -type f -iname "*.prc" -exec cat {} >> ../sp_implementation_script.txt \;
8. execute this command to generate list of file names included with number of files
   $ echo -e "Number of files \n---------------\n`ls -1 | wc -l`\n\nFile Name\n---------" > ../sp_implementation_script_list.txt
   find . -type f -iname "*.prc" -exec ls {} >> ../sp_implementation_script_list.txt \;
9. execute this command in unix (or cygwin for windows)
   find . -type f -iname "*.prc" -exec cat {} >> ../sp_rollback_script.txt \;
   
10. execute this command to generate list of file names included with number of files
    $ echo -e "Number of files \n---------------\n`ls -1 | wc -l`\n\nFile Name\n---------" > ../sp_rollback_script_list.txt
    find . -type f -iname "*.prc" -exec ls {} >> ../sp_rollback_script_list.txt \;