Search results for query: *

Place the code below after your ".BEGIN EXPORT" statement. It is the access module that allows large file system support on solaris. Good luck. .EXPORT AXSMOD /NCRutils_PATH/lf_axsmod.so 'abc'

Thanks. What I need is a little more complex than your suggestion. I have a General purpose letter (in MS Word)that I need to send to customers based on a certain business event. I have written the query to select the names and addresses of all customers who fall in this category. What I need to...

I would like to mail merge the list of addresses from a businiess objects query to MS Word without exporting to excel or a database. Any ideas? Thanks in advance!

You can achieve this by placing multiple queries in one document.(create a new report tab for each Product). The down side is that, you will end up with one pdf file with multiple sections instead of 3 pdf files.

Sorry I don't have an answer for you, but I also want to know how to create these "cascade" prompts. Please send me any examples. Thanks!

Do you have BO installed already? If you do and have licensed Broadcast agent, all you have to do is (1) Login in to Supervisor, (2)Create a new group (3)Double click the New group folder to display the group properties (4)Click the Broadcast agent tab (4)In the User section, select Broadcast...

Looks like there is a universe in the repository with the same name. You can use Supervisor to verify whether or not a universe already exists with the same name. Finally scan and repair your repository. Good luck

It sounds like you are running into deadlock problems. Teradata updates/reads some system tables when you perform deletes and updates. DBC.Accessrights and DBC.TVM are examples of system tables that are accessed. If you have PMON, you can use it to check for locks. If you don't, try selecting...

Make sure you have a C compiler on your system, and that you have enough space in your user_account. Good luck.

Every Terdata query ends with a "Total Elapsed time" . You should be able to redirect the output of the SQL to a file and get the elapsed time from the file ...

Updating or inserting into populated tables in Teradata can be very slow ... Try inserting into an empty table 1st and then merge your newly inserted table with the populated table.

As you mentioned, you can create q3.txt to run both q1.txt and q2.txt by putting the lines below in q3.txt. .run file=q1.txt .run file=q2.txt So your q3.txt will look something like /*******************/ .logon usr/passwd; .run file=q1.txt .run file=q2.txt .exit /*******************/

Yes Erwin supports Teradata. I am using Erwin 3.5.2 to reverse engineer and model tables in Teradata v2r4.

continuing from where JG's suggestion, you can also CAST the timestamp as DATE instead of CHAR ... especially if you intend to perform date arithmetic later no: Create Set Table test_tab (test_col1 Integer NOT NULL ,test_tstamp Timestamp(0)) Primary Index (Test_col1); replace view...

Not sure I understand your requirement, but add this to your hosts file: #IP address #COP[processor] 111.11.1.11 testcop1.company.com 222.22.2.22 testcop2.company.com This assumes a 2-node system. In your middleware configuration file, use "test" as your...

ALTER table does not allow you to change the datatype of a column. Even if it did, I doubt that it will allow you to change the data type of a PI column. -------- Your best bet is to (1) "show table" for all tables (2) Modify the datatype of the columns you want to change (3) Save...

"Role tables" may help .... see one of Mr. Kimball's articles - http://www.dbmsmag.com/9708d05.html Good luck

They are both correct. The position of the columns in the join expression shouldn't matter.

Check the Teradata manuals for date datatype. In teradata the format and precision for current_timestamp is different from the Oracle timestamp. For example on Teradata (1) Select current_timestamp; yields something like 2001-05-18 08:49:42.3+00:00 and in Oracle, Select sysdate from dual...

Does Teradata JDBC driver support Java Transactions API (JTA)? Thanks much!