Browsing Maithili translation

631.

@FUNCTION=EXECSQL
@SYNTAX=EXECSQL(dsn,username,password,sql)
@DESCRIPTION=The EXECSQL function lets you execute a command in a database server, and show the results returned in current sheet. It uses libgda as the means for accessing the databases.
For using it, you need first to set up a libgda data source.
@EXAMPLES=
To get all the data from the table "Customers" present in the "mydatasource" GDA data source, you would use:
EXECSQL("mydatasource","username","password","SELECT * FROM customers")
@SEEALSO=READDBTABLE

632.

@FUNCTION=READDBTABLE
@SYNTAX=READDBTABLE(dsn,username,password,table)
@DESCRIPTION=The READDBTABLE function lets you get the contents of a table, as stored in a database. For using it, you need first to set up a libgda data source.
Note that this function returns all the rows in the given table. If you want to get data from more than one table or want a more precise selection (conditions), use the EXECSQL function.
@EXAMPLES=
To get all the data from the table "Customers" present in the "mydatasource" GDA data source, you would use:
READDBTABLE("mydatasource","username","password","customers")
@SEEALSO=EXECSQL

633.

@FUNCTION=NT_PHI
@SYNTAX=NT_PHI(n)
@DESCRIPTION=NT_PHI function calculates the number of integers less than or equal to @n that are relatively prime to @n.

@EXAMPLES=
@SEEALSO=NT_D, ITHPRIME, NT_SIGMA

634.

@FUNCTION=NT_MU
@SYNTAX=NT_MU(n)
@DESCRIPTION=NT_MU function (Möbius mu function) returns
0 if @n is divisible by the square of a prime .
Otherwise it returns:

-1 if @n has an odd number of different prime factors .
1 if @n has an even number of different prime factors .

* If @n = 1 NT_MU returns 1.

@EXAMPLES=
@SEEALSO=NT_D, ITHPRIME, NT_PHI

635.

@FUNCTION=NT_D
@SYNTAX=NT_D(n)
@DESCRIPTION=NT_D function calculates the number of divisors of @n.

@EXAMPLES=
@SEEALSO=ITHPRIME, NT_PHI, NT_SIGMA

636.

@FUNCTION=NT_SIGMA
@SYNTAX=NT_SIGMA(n)
@DESCRIPTION=NT_SIGMA function calculates the sum of the divisors of @n.

@EXAMPLES=
@SEEALSO=NT_D, ITHPRIME, NT_PHI

637.

@FUNCTION=ITHPRIME
@SYNTAX=ITHPRIME(i)
@DESCRIPTION=ITHPRIME function returns the @ith prime.

@EXAMPLES=
@SEEALSO=NT_D, NT_SIGMA

638.

@FUNCTION=ISPRIME
@SYNTAX=ISPRIME(i)
@DESCRIPTION=ISPRIME function returns TRUE if @i is prime and FALSE otherwise.

@EXAMPLES=
@SEEALSO=ITHPRIME, NT_D, NT_SIGMA

639.

@FUNCTION=PFACTOR
@SYNTAX=PFACTOR(n)
@DESCRIPTION=PFACTOR function returns the smallest prime factor of its argument.

The argument must be at least 2, or else a #VALUE! error is returned.

@EXAMPLES=
@SEEALSO=ITHPRIME

640.

@FUNCTION=NT_PI
@SYNTAX=NT_PI(n)
@DESCRIPTION=NT_PI function returns the number of primes less than or equal to @n.

@EXAMPLES=
@SEEALSO=ITHPRIME, NT_PHI, NT_D, NT_SIGMA