Tip Bank

Question: I am using Informix 7.24 and my raw partitions are getting quite large. Is there a way to tell the size of a database? I could then decide which

Question: Can I specify the column I want to select from as an argument to the procedure? Something like: create procedure show_product(language char(2), ID integer) returning char(255);define p_prod_name CHAR (255);select

Question: What are some of the ways that databases can be secured so that they can’t be hacked into, etc.? Answer: The first level of security is always the OS

Question: Is there a way to perform a selective restore? I need to restore just one mailbox or public folder. I’m using the NT backup/restore utility. Answer: I’m afraid not.

‘ Format a credit card numberFunction FormatCreditCard(ByVal text As String) As String Dim i As Long ‘ ignore empty strings If Len(text) = 0 Then Exit Function ‘ get rid

‘ convert a string to camel case’ for example: CamelCase(“new file name”) => “NewFileName”‘Function CamelCase(ByVal Text As String) As String Dim i As Long ‘ convert all non-alphanumeric chars to

‘ convert a reversed full name back to the “FirstName LastName” format” for example, ConvertReverseFullName(“Smith, John A.”) ==> “John A. Smith”Function ConvertReverseFullName(ByVal ReverseFullName As String) As String Dim i As

‘ Modify a phone-number to the format “XXX-XXXX” or “(XXX) XXX-XXXX”.Function FormatPhoneNumber(ByVal text As String) As String Dim i As Long ‘ ignore empty strings If Len(text) = 0 Then

‘ Takes a first and last name and converts it to the format LastName, FirstNameFunction FormatFullName(ByVal FirstName As String, ByVal LastName As String) As _ String FirstName = Trim$(FirstName) LastName