Can an extended stored procedure be called from inside a user-defined function?
Which data type cannot be used as a parameter in a udf?
You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?
Explain about relational operator join?
explain detail about ftp in datastage?
How would you design a database for an online site, which would average a million hits a day?
When installing the datastage7.5x2 edtion iam getting aproblem i.e the cpu count is 2 but the cpu count in installation is one . how can i install in my p.c (system is dual core).
Explain what a database is?
You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?
What is the maximum length of an extended property?
Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?
How to use timestamp datatypes
Who are end users in dbms?
Explain about relational database management systems?
What is an application role and explain a scenario when you would use one?