[U2] Job Opening in Boston: Experienced Pick/Universe/Unidata for QA work
My client, a software product development company based in Boston, has an opening for a Mid-level Software QA Engineer with experiences in PICK. This is a permanent full time position. QA experiences are not necessary. PICK programming experiences are required. If interested, please EMAIL your resume as a WORD attachment to: [EMAIL PROTECTED] Thank you... Ben Ben Oifer Technical Futures, Inc. 18 Washington Street, #205 Canton, MA 02021 Phone: (781) 793-9292 Email: [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] BCI and Dates to SqlServer
BCI mimics the ODBC API, so dates are expected to be in ODBC format (-MM-DD). Using the constant SQL.B.DATE in SQLBindParameter() or SQLBindColumn() causes an implicit conversion to occur, so that you get internal format out of a SELECT, and must supply internal format in bound variables to an INSERT or UPDATE. HTH --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [u2] Community :: U2canXML :: Any examples of a valid extraction file?
-Original Message- From: U2 Users Group, International [mailto:[EMAIL PROTECTED] Sent: Friday, 25 March 2005 5:10 AM To: [EMAIL PROTECTED] Subject: Community :: U2canXML :: Any examples of a valid extraction file? Forums U2 Users Group, International Community :: U2canXML ::.. Any examples of a valid extraction file? sfulkerson wrote at Mar 24, 2005 - 01:09 PM - I've been trying to get UV10.0 to read XML files, but having no luck. IBM's docs and code examples are useless. Can anyone who as succeeded in getting PrepareXML to work please post an example? Does anyone have some information to assist this user question below that they could post to the U2UG u2canxml forum. Thanks David Jordan Here is what I've tried, based on IBM's docs: [CODE] [/CODE]We're not ready to ugrade to 10.1, which I see has much better XML functionality. I'm nearly to the point where I'm going to write my own parser. Thanks in advance, Sean Fulkerson - Reply to this message: http://www.u2ug.org/modules.php?op=modloadname=phpBB_14file=indexaction=r eplytopic=344forum=19 Browse thread: http://www.u2ug.org/modules.php?op=modloadname=phpBB_14file=indexaction=v iewtopictopic=344 You are receiving this Email because you are subscribed to be notified of events in forums at: http://www.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re[2]: [U2] BCI and Dates to SqlServer
Ray, Thursday, March 24, 2005, 1:52:39 PM, you wrote: RW BCI mimics the ODBC API, so dates are expected to be in ODBC format (-MM-DD). yes .. RW Using the constant SQL.B.DATE in SQLBindParameter() or RW SQLBindColumn() causes an implicit conversion to occur, so that RW you get internal format out of a SELECT, and must supply internal RW format in bound variables to an INSERT or UPDATE. I do use the SQL.B.INTDATE and SQL.DATE. MsSql creates as datetime (using Enterprise Manager) .. As soon as i try to write to this column i get the error. If i change the column to 'char' in all places then it writes out correctly. It is only DATE that i have any problems with (haven't tried time). INTs chars varchars (which map also to text columns) etc work well. It is only date .. it must be something on my end as I would find it odd that there is some ambiguity in the uv - odbc interface -- DSig ` David Tod Sigafoos ( O O ) ___oOOo__( )__oOOo___ Cannot open file C:\DOCUMENTS AND SETTINGS\DAVID TOD SIGAFOOS\APPLICATION DATA\BATMAIL\COOKIES.TXT --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Timothy Snyder/Philadelphia/IBM is out of the office.
I will be out of the office starting 03/23/2005 and will not return until 03/28/2005. I will respond to your message as soon as possible. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re[2]: [U2] BCI and Dates to SqlServer
Ray, Thursday, March 24, 2005, 1:52:39 PM, you wrote: snip as further follow up here is a sample routine and info. Note that that the only problem shows up after the sqlExecute .. and it is caused by the write .. RUN DAVES.BP DATE_TEST.MV Program: DATE_TEST Status for sqlExecute call is: -1 SQLSTATE,NATCOD are:S1C00 0 Error text is [IBM][SQL Client][ODBC][Microsoft][ODBC SQL Server Driver]Optional feature n ot implemented Program DATE_TEST.MV: Line 69, Cannot resolve ERRMSG item EXITING CKSTMTENV. sql definition: tableName = testDate columns nbr int testDatedatetime --- program = 'DATE_TEST' include UNIVERSE.INCLUDE ODBC.H equ TRUE$ to 1 equ FALSE$ to 0 equ NULL$ to '' if (SQLAllocEnv(comBaseEnv) SQL.SUCCESS) SQL.SUCCESS then stop 'allocEnv' if (SQLAllocConnect(comBaseEnv, comConnEnv) SQL.SUCCESS) then stop 'allocConnect' if (SQLConnect(comConnEnv, 'Universe','Universe','universe') SQL.SUCCESS) then stop 'Connect' if (SQLAllocStmt(comConnEnv, sqlStmtEnv) SQL.SUCCESS) SQL.SUCCESS then stop 'allocStmt' nbr = NULL$ date = NULL$ if (SQLBindParameter(sqlStmtEnv, 1, SQL.B.BASIC, SQL.INTEGER, 4, 0, nbr) SQL.SUCCESS) then stop 'BP nbr' if (SQLBindParameter(sqlStmtEnv, 2, SQL.B.INTDATE, SQL.DATE, 30, 0, date) SQL.SUCCESS) then stop 'date' sqlStatement = 'insert into testDate values (?,?)' IF (SQLPrepare(sqlStmtEnv, sqlStatement) SQL.SUCCESS) then stop 'prepare' nbr = 1 date = 13598 status = sqlExecute(sqlStmtEnv) if status SQL.SUCCESS then sqlRoutine = 'sqlExecute' gosub CKSTMTENV end STOP CKSTMTENV: STATUS = status Fn = sqlRoutine Expect = '' IF STATUS EQ -2 THEN status = SQLFreeStmt(sqlStmtEnv, SQL.DROP) STOP INVALID STATEMENT HANDLE end IF STATUS EQ 100 THEN RETURN IF STATUS NE 0 THEN 301* ST = SQLERROR(-1,-1,sqlStmtEnv,STATE,NATCODE,ERRTXT) IF ST SQL.NO.DATA.FOUND THEN PRINT COUNT = 1 IF Expect NE 0 AND STATE = Expect AND ST SQL.NO.DATA.FOUND THEN PRINT Allowed error of :STATE: returned for func :Fn GOTO 399 END ELSE PRINT 'Program: ': program PRINT Status for :Fn: call is: :STATUS PRINT SQLSTATE,NATCOD are: : STATE: :NATCODE PRINT Error text is PRINT : ERRTXT END IF ST = 0 THEN GOTO 301 END IF STATUS = -1 AND COUNT = 1 THEN status = SQLFreeStmt(sqlStmtEnv, SQL.DROP) STOP EXITING CKSTMTENV end END 399* IF STATUS 0 THEN PRINT RETURN -- DSig ` David Tod Sigafoos ( O O ) ___oOOo__( )__oOOo___ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/