search for: nullstring

There is something strange in R behaviour (perhaps). I have run the same select in Oracle SQL*Plus (version 10.1.0.2.0) and the output comes out with NULLs (which is what it ougth to be). But in R I still get the same result with NAs (no matter I use na.strings or nullstring arguments) An output example follows below: Using na.string="0" and nullstring="0" (sorry by the indents): Length 2003 2002 2001 2000 1999 1998 1997 1996 1995 1 32 NA 1 NA NA NA NA NA 2 NA 2 34 3 NA NA NA NA NA NA 6 NA 3...

...Thank you for your replies but the door is still open so as to know a solution to the select without coercing NAs to 0s after retrieving the data Best, Luis >>> Prof Brian Ripley <ripley at stats.ox.ac.uk> 12/01/2005 11:21:33 >>> PLEASE do read the help page, which says nullstring: character string to be used when reading 'SQL_NULL_DATA' character items from the database. ^^^^^^^^^^^^^^^ so this does not apply to numeric items. You can of course easily change numeric NAs to 0s, if you want to. On Wed, 12 Jan 2005, Luis Rideau Cruz wrote: >...

R-help, I'm using the RODBC package to retrieve data froma ODBC database which contain NA's. By using the argument nullstring = "0" in sqlQuery() I expect to coerce them to numeric but still get NA's in my select. I'm running on Windows XP > version _ platform i386-pc-mingw32 arch i386 os mingw32 system i386, mingw32 status m...

New clangs emit some warnings. The code isn't wrong, but should be updated to prevent warning creep. Bill Wendling (3): [klibc] dash: shell: Fix clang warnings [klibc] dash: shell: Fix clang warnings about format string [klibc] Kbuild: use an enum to silence a clang warning usr/dash/eval.c | 6 +++--- usr/dash/jobs.c | 2 +- usr/kinit/nfsmount/dummypmap.c

Commit-ID: 6e48f19172d90268f524bf1a3788f7c023b24391 Gitweb: http://git.kernel.org/?p=libs/klibc/klibc.git;a=commit;h=6e48f19172d90268f524bf1a3788f7c023b24391 Author: Herbert Xu <herbert at gondor.apana.org.au> AuthorDate: Sat, 19 May 2018 02:39:48 +0800 Committer: Ben Hutchings <ben at decadent.org.uk> CommitDate: Sat, 28 Mar 2020 21:42:55 +0000 [klibc] dash: exec: Do not

...sqlGetResults to get the same result (and the same error) > library(RODBC) > channel <- odbcConnect("OraLSH", <user>, <password>) > odbcQuery (channel, "select sysdate from dual") > sqlGetResults(channel, as.is=FALSE, errors=FALSE, max=0, buffsize=1, nullstring=NA, na.strings="NA", believeNRows=TRUE, dec=getOption("dec")) Which returns the same error, namely: Error in .Call(C_RODBCFetchRows, attr(channel, "handle_ptr"), max, buffsize, : negative length vectors are not allowed > However, if I modify the value of max=0 (...

...sqlGetResults to get the same result (and the same error) > library(RODBC) > channel <- odbcConnect("OraLSH", <user>, <password>) > odbcQuery (channel, "select sysdate from dual") > sqlGetResults(channel, as.is=FALSE, errors=FALSE, max=0, buffsize=1, nullstring=NA, na.strings="NA", believeNRows=TRUE, dec=getOption("dec")) Which returns the same error, namely: Error in .Call(C_RODBCFetchRows, attr(channel, "handle_ptr"), max, buffsize, : negative length vectors are not allowed > However, if I modify the value of max=0 (...

The getpwd() function in dash assumed than getcwd(0, 0) will allocate the buffer dynamically using malloc(); however, this glibc extension is not implemented by klibc. Make getpwd() use a temporary buffer and invoke savestr() itself instead of relying on a nonstandard extension. Signed-off-by: Sergey Vlasov <vsu at altlinux.ru> --- Alternatively, you may pull from the following git repo

From: maximilian attems <max at stro.at> On review of klibc dash changes: "Hmm, this breaks the non-glibc case. You're now returning a pointer to a string on the stack which is illegal." Herbert Xu Use upstream dash way. Signed-off-by: maximilian attems <max at stro.at> Cc: Herbert Xu <herbert at gondor.apana.org.au> --- usr/dash/cd.c | 7 ++++--- 1 files

...| | 13 | 1 1 | 5 | | | 10 | 0 10 | 13 | 13 | | 22 | 0 However, these are all converted to zeros when I use RODBC's sqlQuery(), making interpretation impossible. I have tried using the nullstring and na.strings options, but these don't seem to have any effect. I have tried various combinations of NULL, NA and "". Forgive my awkward SQL. > channel = odbcConnect("ataxia", uid="mark") > disease = sqlQuery(channel, "select calc_survival_unilateral_s...

- Convert the "old style" GNU field designator extension to the new style. - Use proper indexing into a string literal. - Use "%s" for the format string in "fmtstr". - Add or remove casts of the "void *" argument of ioctl. - Convert "if (!exitstatus == isor)" to "if ((!exitstatus) == isor)" which retains the current semantics, but may

Commit-ID: 604d3a0a1570f3478360913c2935ea53d18857e6 Gitweb: http://git.kernel.org/?p=libs/klibc/klibc.git;a=commit;h=604d3a0a1570f3478360913c2935ea53d18857e6 Author: Herbert Xu <herbert at gondor.apana.org.au> AuthorDate: Sat, 19 May 2018 02:39:50 +0800 Committer: Ben Hutchings <ben at decadent.org.uk> CommitDate: Sat, 28 Mar 2020 21:42:55 +0000 [klibc] dash: exec: Stricter

Commit-ID: 166a88f4568067378ddce23b91be7b4ec9a9dfb4 Gitweb: http://git.kernel.org/?p=libs/klibc/klibc.git;a=commit;h=166a88f4568067378ddce23b91be7b4ec9a9dfb4 Author: Herbert Xu <herbert at gondor.apana.org.au> AuthorDate: Sat, 19 May 2018 02:39:52 +0800 Committer: Ben Hutchings <ben at decadent.org.uk> CommitDate: Sat, 28 Mar 2020 21:42:55 +0000 [klibc] dash: eval: Add

Description of problem: libvirt 3.9 on CentOS Linux release 7.4.1708 (kernel 3.10.0-693.21.1.el7.x86_64) on Qemu version 2.10.0 I’m currently facing a strange situation. Sometimes my vm is shown by ‘virsh list’ as in state “in shutdown” but there is no qemu-kvm process linked to it. Libvirt log when “in shutdown” state occur is as follows: “d470c3b284425b9bacb34d3b5f3845fe” is vm’s name,

xdpyinfo is a command line utility for printing information about an X server. Alan Coopersmith (8): Print which option was in error along with usage message Sprinkle consts in StrCmp to quiet cast warnings config: Add missing AC_CONFIG_SRCDIR configure: Drop AM_MAINTAINER_MODE autogen.sh: Honor NOCONFIGURE=1 Mark required arguments to Xlib error handler as

Commit-ID: cf7826f66c01eed24475a140d934b7a75b28d23e Gitweb: http://git.kernel.org/?p=libs/klibc/klibc.git;a=commit;h=cf7826f66c01eed24475a140d934b7a75b28d23e Author: Herbert Xu <herbert at gondor.apana.org.au> AuthorDate: Mon, 27 Oct 2014 16:56:46 +0800 Committer: Ben Hutchings <ben at decadent.org.uk> CommitDate: Fri, 25 Jan 2019 02:57:21 +0000 [klibc] [BUILTIN] Handle --

Commit-ID: ee64e00783293e0ef19e191632d99b2b3a68fc4d Gitweb: http://git.kernel.org/?p=libs/klibc/klibc.git;a=commit;h=ee64e00783293e0ef19e191632d99b2b3a68fc4d Author: Herbert Xu <herbert at gondor.apana.org.au> AuthorDate: Thu, 22 Mar 2018 17:32:55 +0800 Committer: Ben Hutchings <ben at decadent.org.uk> CommitDate: Fri, 25 Jan 2019 02:57:21 +0000 [klibc] expand: Fix bugs with

Commit-ID: b29bd471a98347d6bd6b165062558733152e30f6 Gitweb: http://git.kernel.org/?p=libs/klibc/klibc.git;a=commit;h=b29bd471a98347d6bd6b165062558733152e30f6 Author: Herbert Xu <herbert at gondor.apana.org.au> AuthorDate: Sun, 25 Mar 2018 15:55:40 +0800 Committer: Ben Hutchings <ben at decadent.org.uk> CommitDate: Fri, 25 Jan 2019 02:57:21 +0000 [klibc] builtin: Move echo

Commit-ID: 6297d755e71777d4fcf55d106d11f9e631fa547f Gitweb: http://git.kernel.org/?p=libs/klibc/klibc.git;a=commit;h=6297d755e71777d4fcf55d106d11f9e631fa547f Author: Herbert Xu <herbert at gondor.apana.org.au> AuthorDate: Mon, 27 Oct 2014 16:56:46 +0800 Committer: Ben Hutchings <ben at decadent.org.uk> CommitDate: Sat, 28 Mar 2020 21:42:54 +0000 [klibc] dash: [BUILTIN]

Commit-ID: f4d7a34b1ec9a2238179a48eac757478736c9ca6 Gitweb: http://git.kernel.org/?p=libs/klibc/klibc.git;a=commit;h=f4d7a34b1ec9a2238179a48eac757478736c9ca6 Author: Herbert Xu <herbert at gondor.apana.org.au> AuthorDate: Thu, 22 Mar 2018 17:32:55 +0800 Committer: Ben Hutchings <ben at decadent.org.uk> CommitDate: Sat, 28 Mar 2020 21:42:54 +0000 [klibc] dash: expand: Fix