Re[2]: [U2] BCI and Dates to SqlServer

2005-03-24 Thread David Tod Sigafoos
Ray, Thursday, March 24, 2005, 1:52:39 PM, you wrote: 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

[U2] Timothy Snyder/Philadelphia/IBM is out of the office.

2005-03-24 Thread Timothy Snyder
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

2005-03-24 Thread David Tod Sigafoos
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

[U2] [u2] Community :: U2canXML :: Any examples of a valid extraction file?

2005-03-24 Thread David Jordan
-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 example

Re: [U2] BCI and Dates to SqlServer

2005-03-24 Thread Ray Wurlod
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

[U2] Job Opening in Boston: Experienced Pick/Universe/Unidata for QA work

2005-03-24 Thread Ben Oifer, Technical Futures, Inc.
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 res

[U2] BCI and Dates to SqlServer

2005-03-24 Thread David Tod Sigafoos
u2-users, Anyone out there have any experience with the Basic SQL Client Interface and connection to MS SqlServer? Specifically having problems with DATE .. continually getting 'feature not implemented' .. oh my -- DSig David Tod Sigafoos --- u2-users mailing list u2-users@lists

Re: [U2] [UV] Distributed SELECTs for distributed (Type30) files

2005-03-24 Thread CWNoah2
Chuck, We do exactly that in Jbase (also did it in UV). It is especially useful in EOD/EOM processing. We have our product files distributed by our 25 stores. We've found that you need to limit the select phantoms to a smaller number of concurrent processes. With our present configuration (