Search results for query: *

# xctl -nw It will list the current running dbs n pde version. # xctl -nw > hardware It will list the hardware information.

Try using Coalesce function to avoid generation of NULL values - SELECT COALESCE (('axt'||TRIM(RANDOM( 10, 100)) || TRIM(RANDOM( 10,100 )) || TRIM(RANDOM( 10,100))||SUBSTR(DATE (FORMAT 'YYYYMMDD') ,5,2)||SUBSTR(DATE (FORMAT 'YYYYMMDD') ,7,2)),0) INTO :VarPasswd; INSERT INTO PwdFile( col1 )...

What is the version of Teradata ODBC Driver are you using ? 16-bit drivers are quite old for Teradata and it could be possible for IBM also. Try getting 32-bit drivers.....

Try this to call the procedure - .CommandText = "CALL testSP(5,""strout"")"

am assuming that u r trying to submit a stored procedure. u cannot perform SELECT in sp. u need to have SELECT INTO. Try referencing manual provided by Teradata. These manual are also available on www.ncr.com

Through PMON u can check if any sql is still executing. Check through show locks if any locks are there. Check through Qryman the progress of the session.

am not very sure, but since the second parameter is Out, so u should specify an variable instead of value while calling the sp. did u try this option.

If the session character set is UTF8 then the client is telling Teradata that it wants to insert UTF8 characters. So it is necessary that the data sent to the database is of the UTF8 format. Need to convert in this case as the driver offers no translation to UTF8 character data to be finally...