1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
|
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /><title>36.15. Informix Compatibility Mode</title><link rel="stylesheet" type="text/css" href="stylesheet.css" /><link rev="made" href="pgsql-docs@lists.postgresql.org" /><meta name="generator" content="DocBook XSL Stylesheets Vsnapshot" /><link rel="prev" href="ecpg-sql-whenever.html" title="WHENEVER" /><link rel="next" href="ecpg-oracle-compat.html" title="36.16. Oracle Compatibility Mode" /></head><body id="docContent" class="container-fluid col-10"><div class="navheader"><table width="100%" summary="Navigation header"><tr><th colspan="5" align="center">36.15. <span class="productname">Informix</span> Compatibility Mode</th></tr><tr><td width="10%" align="left"><a accesskey="p" href="ecpg-sql-whenever.html" title="WHENEVER">Prev</a> </td><td width="10%" align="left"><a accesskey="u" href="ecpg.html" title="Chapter 36. ECPG — Embedded SQL in C">Up</a></td><th width="60%" align="center">Chapter 36. <span class="application">ECPG</span> — Embedded <acronym class="acronym">SQL</acronym> in C</th><td width="10%" align="right"><a accesskey="h" href="index.html" title="PostgreSQL 16.2 Documentation">Home</a></td><td width="10%" align="right"> <a accesskey="n" href="ecpg-oracle-compat.html" title="36.16. Oracle Compatibility Mode">Next</a></td></tr></table><hr /></div><div class="sect1" id="ECPG-INFORMIX-COMPAT"><div class="titlepage"><div><div><h2 class="title" style="clear: both">36.15. <span class="productname">Informix</span> Compatibility Mode <a href="#ECPG-INFORMIX-COMPAT" class="id_link">#</a></h2></div></div></div><div class="toc"><dl class="toc"><dt><span class="sect2"><a href="ecpg-informix-compat.html#ECPG-INFORMIX-TYPES">36.15.1. Additional Types</a></span></dt><dt><span class="sect2"><a href="ecpg-informix-compat.html#ECPG-INFORMIX-STATEMENTS">36.15.2. Additional/Missing Embedded SQL Statements</a></span></dt><dt><span class="sect2"><a href="ecpg-informix-compat.html#ECPG-INFORMIX-SQLDA">36.15.3. Informix-compatible SQLDA Descriptor Areas</a></span></dt><dt><span class="sect2"><a href="ecpg-informix-compat.html#ECPG-INFORMIX-FUNCTIONS">36.15.4. Additional Functions</a></span></dt><dt><span class="sect2"><a href="ecpg-informix-compat.html#ECPG-INFORMIX-CONSTANTS">36.15.5. Additional Constants</a></span></dt></dl></div><p>
<code class="command">ecpg</code> can be run in a so-called <em class="firstterm">Informix compatibility mode</em>. If
this mode is active, it tries to behave as if it were the <span class="productname">Informix</span>
precompiler for <span class="productname">Informix</span> E/SQL. Generally spoken this will allow you to use
the dollar sign instead of the <code class="literal">EXEC SQL</code> primitive to introduce
embedded SQL commands:
</p><pre class="programlisting">
$int j = 3;
$CONNECT TO :dbname;
$CREATE TABLE test(i INT PRIMARY KEY, j INT);
$INSERT INTO test(i, j) VALUES (7, :j);
$COMMIT;
</pre><p>
</p><div class="note"><h3 class="title">Note</h3><p>
There must not be any white space between the <code class="literal">$</code>
and a following preprocessor directive, that is,
<code class="literal">include</code>, <code class="literal">define</code>, <code class="literal">ifdef</code>,
etc. Otherwise, the preprocessor will parse the token as a host
variable.
</p></div><p>
There are two compatibility modes: <code class="literal">INFORMIX</code>, <code class="literal">INFORMIX_SE</code>
</p><p>
When linking programs that use this compatibility mode, remember to link
against <code class="literal">libcompat</code> that is shipped with ECPG.
</p><p>
Besides the previously explained syntactic sugar, the <span class="productname">Informix</span> compatibility
mode ports some functions for input, output and transformation of data as
well as embedded SQL statements known from E/SQL to ECPG.
</p><p>
<span class="productname">Informix</span> compatibility mode is closely connected to the pgtypeslib library
of ECPG. pgtypeslib maps SQL data types to data types within the C host
program and most of the additional functions of the <span class="productname">Informix</span> compatibility
mode allow you to operate on those C host program types. Note however that
the extent of the compatibility is limited. It does not try to copy <span class="productname">Informix</span>
behavior; it allows you to do more or less the same operations and gives
you functions that have the same name and the same basic behavior but it is
no drop-in replacement if you are using <span class="productname">Informix</span> at the moment. Moreover,
some of the data types are different. For example,
<span class="productname">PostgreSQL</span>'s datetime and interval types do not
know about ranges like for example <code class="literal">YEAR TO MINUTE</code> so you won't
find support in ECPG for that either.
</p><div class="sect2" id="ECPG-INFORMIX-TYPES"><div class="titlepage"><div><div><h3 class="title">36.15.1. Additional Types <a href="#ECPG-INFORMIX-TYPES" class="id_link">#</a></h3></div></div></div><p>
The Informix-special "string" pseudo-type for storing right-trimmed character string data is now
supported in Informix-mode without using <code class="literal">typedef</code>. In fact, in Informix-mode,
ECPG refuses to process source files that contain <code class="literal">typedef sometype string;</code>
</p><pre class="programlisting">
EXEC SQL BEGIN DECLARE SECTION;
string userid; /* this variable will contain trimmed data */
EXEC SQL END DECLARE SECTION;
EXEC SQL FETCH MYCUR INTO :userid;
</pre><p>
</p></div><div class="sect2" id="ECPG-INFORMIX-STATEMENTS"><div class="titlepage"><div><div><h3 class="title">36.15.2. Additional/Missing Embedded SQL Statements <a href="#ECPG-INFORMIX-STATEMENTS" class="id_link">#</a></h3></div></div></div><p>
</p><div class="variablelist"><dl class="variablelist"><dt id="ECPG-INFORMIX-STATEMENTS-CLOSE-DATABASE"><span class="term"><code class="literal">CLOSE DATABASE</code></span> <a href="#ECPG-INFORMIX-STATEMENTS-CLOSE-DATABASE" class="id_link">#</a></dt><dd><p>
This statement closes the current connection. In fact, this is a
synonym for ECPG's <code class="literal">DISCONNECT CURRENT</code>:
</p><pre class="programlisting">
$CLOSE DATABASE; /* close the current connection */
EXEC SQL CLOSE DATABASE;
</pre><p>
</p></dd><dt id="ECPG-INFORMIX-STATEMENTS-FREE-CURSOR-NAME"><span class="term"><code class="literal">FREE cursor_name</code></span> <a href="#ECPG-INFORMIX-STATEMENTS-FREE-CURSOR-NAME" class="id_link">#</a></dt><dd><p>
Due to differences in how ECPG works compared to Informix's ESQL/C (namely, which steps
are purely grammar transformations and which steps rely on the underlying run-time library)
there is no <code class="literal">FREE cursor_name</code> statement in ECPG. This is because in ECPG,
<code class="literal">DECLARE CURSOR</code> doesn't translate to a function call into
the run-time library that uses to the cursor name. This means that there's no run-time
bookkeeping of SQL cursors in the ECPG run-time library, only in the PostgreSQL server.
</p></dd><dt id="ECPG-INFORMIX-STATEMENTS-FREE-STATEMENT-NAME"><span class="term"><code class="literal">FREE statement_name</code></span> <a href="#ECPG-INFORMIX-STATEMENTS-FREE-STATEMENT-NAME" class="id_link">#</a></dt><dd><p>
<code class="literal">FREE statement_name</code> is a synonym for <code class="literal">DEALLOCATE PREPARE statement_name</code>.
</p></dd></dl></div><p>
</p></div><div class="sect2" id="ECPG-INFORMIX-SQLDA"><div class="titlepage"><div><div><h3 class="title">36.15.3. Informix-compatible SQLDA Descriptor Areas <a href="#ECPG-INFORMIX-SQLDA" class="id_link">#</a></h3></div></div></div><p>
Informix-compatible mode supports a different structure than the one described in
<a class="xref" href="ecpg-descriptors.html#ECPG-SQLDA-DESCRIPTORS" title="36.7.2. SQLDA Descriptor Areas">Section 36.7.2</a>. See below:
</p><pre class="programlisting">
struct sqlvar_compat
{
short sqltype;
int sqllen;
char *sqldata;
short *sqlind;
char *sqlname;
char *sqlformat;
short sqlitype;
short sqlilen;
char *sqlidata;
int sqlxid;
char *sqltypename;
short sqltypelen;
short sqlownerlen;
short sqlsourcetype;
char *sqlownername;
int sqlsourceid;
char *sqlilongdata;
int sqlflags;
void *sqlreserved;
};
struct sqlda_compat
{
short sqld;
struct sqlvar_compat *sqlvar;
char desc_name[19];
short desc_occ;
struct sqlda_compat *desc_next;
void *reserved;
};
typedef struct sqlvar_compat sqlvar_t;
typedef struct sqlda_compat sqlda_t;
</pre><p>
</p><p>
The global properties are:
</p><div class="variablelist"><dl class="variablelist"><dt id="ECPG-INFORMIX-SQLDA-SQLD"><span class="term"><code class="literal">sqld</code></span> <a href="#ECPG-INFORMIX-SQLDA-SQLD" class="id_link">#</a></dt><dd><p>
The number of fields in the <code class="literal">SQLDA</code> descriptor.
</p></dd><dt id="ECPG-INFORMIX-SQLDA-SQLVAR"><span class="term"><code class="literal">sqlvar</code></span> <a href="#ECPG-INFORMIX-SQLDA-SQLVAR" class="id_link">#</a></dt><dd><p>
Pointer to the per-field properties.
</p></dd><dt id="ECPG-INFORMIX-SQLDA-DESC-NAME"><span class="term"><code class="literal">desc_name</code></span> <a href="#ECPG-INFORMIX-SQLDA-DESC-NAME" class="id_link">#</a></dt><dd><p>
Unused, filled with zero-bytes.
</p></dd><dt id="ECPG-INFORMIX-SQLDA-DESC-OCC"><span class="term"><code class="literal">desc_occ</code></span> <a href="#ECPG-INFORMIX-SQLDA-DESC-OCC" class="id_link">#</a></dt><dd><p>
Size of the allocated structure.
</p></dd><dt id="ECPG-INFORMIX-SQLDA-DESC-NEXT"><span class="term"><code class="literal">desc_next</code></span> <a href="#ECPG-INFORMIX-SQLDA-DESC-NEXT" class="id_link">#</a></dt><dd><p>
Pointer to the next SQLDA structure if the result set contains more than one record.
</p></dd><dt id="ECPG-INFORMIX-SQLDA-RESERVED"><span class="term"><code class="literal">reserved</code></span> <a href="#ECPG-INFORMIX-SQLDA-RESERVED" class="id_link">#</a></dt><dd><p>
Unused pointer, contains NULL. Kept for Informix-compatibility.
</p></dd></dl></div><p>
The per-field properties are below, they are stored in the <code class="literal">sqlvar</code> array:
</p><div class="variablelist"><dl class="variablelist"><dt id="ECPG-INFORMIX-SQLDA-SQLTYPE"><span class="term"><code class="literal">sqltype</code></span> <a href="#ECPG-INFORMIX-SQLDA-SQLTYPE" class="id_link">#</a></dt><dd><p>
Type of the field. Constants are in <code class="literal">sqltypes.h</code>
</p></dd><dt id="ECPG-INFORMIX-SQLDA-SQLLEN"><span class="term"><code class="literal">sqllen</code></span> <a href="#ECPG-INFORMIX-SQLDA-SQLLEN" class="id_link">#</a></dt><dd><p>
Length of the field data.
</p></dd><dt id="ECPG-INFORMIX-SQLDA-SQLDATA"><span class="term"><code class="literal">sqldata</code></span> <a href="#ECPG-INFORMIX-SQLDA-SQLDATA" class="id_link">#</a></dt><dd><p>
Pointer to the field data. The pointer is of <code class="literal">char *</code> type,
the data pointed by it is in a binary format. Example:
</p><pre class="programlisting">
int intval;
switch (sqldata->sqlvar[i].sqltype)
{
case SQLINTEGER:
intval = *(int *)sqldata->sqlvar[i].sqldata;
break;
...
}
</pre><p>
</p></dd><dt id="ECPG-INFORMIX-SQLDA-SQLIND"><span class="term"><code class="literal">sqlind</code></span> <a href="#ECPG-INFORMIX-SQLDA-SQLIND" class="id_link">#</a></dt><dd><p>
Pointer to the NULL indicator. If returned by DESCRIBE or FETCH then it's always a valid pointer.
If used as input for <code class="literal">EXECUTE ... USING sqlda;</code> then NULL-pointer value means
that the value for this field is non-NULL. Otherwise a valid pointer and <code class="literal">sqlitype</code>
has to be properly set. Example:
</p><pre class="programlisting">
if (*(int2 *)sqldata->sqlvar[i].sqlind != 0)
printf("value is NULL\n");
</pre><p>
</p></dd><dt id="ECPG-INFORMIX-SQLDA-SQLNAME"><span class="term"><code class="literal">sqlname</code></span> <a href="#ECPG-INFORMIX-SQLDA-SQLNAME" class="id_link">#</a></dt><dd><p>
Name of the field. 0-terminated string.
</p></dd><dt id="ECPG-INFORMIX-SQLDA-SQLFORMAT"><span class="term"><code class="literal">sqlformat</code></span> <a href="#ECPG-INFORMIX-SQLDA-SQLFORMAT" class="id_link">#</a></dt><dd><p>
Reserved in Informix, value of <a class="xref" href="libpq-exec.html#LIBPQ-PQFFORMAT"><code class="function">PQfformat</code></a> for the field.
</p></dd><dt id="ECPG-INFORMIX-SQLDA-SQLITYPE"><span class="term"><code class="literal">sqlitype</code></span> <a href="#ECPG-INFORMIX-SQLDA-SQLITYPE" class="id_link">#</a></dt><dd><p>
Type of the NULL indicator data. It's always SQLSMINT when returning data from the server.
When the <code class="literal">SQLDA</code> is used for a parameterized query, the data is treated
according to the set type.
</p></dd><dt id="ECPG-INFORMIX-SQLDA-SQLILEN"><span class="term"><code class="literal">sqlilen</code></span> <a href="#ECPG-INFORMIX-SQLDA-SQLILEN" class="id_link">#</a></dt><dd><p>
Length of the NULL indicator data.
</p></dd><dt id="ECPG-INFORMIX-SQLDA-SQLXID"><span class="term"><code class="literal">sqlxid</code></span> <a href="#ECPG-INFORMIX-SQLDA-SQLXID" class="id_link">#</a></dt><dd><p>
Extended type of the field, result of <a class="xref" href="libpq-exec.html#LIBPQ-PQFTYPE"><code class="function">PQftype</code></a>.
</p></dd><dt id="ECPG-INFORMIX-SQLDA-SQLTYPENAME"><span class="term"><code class="literal">sqltypename</code><br /></span><span class="term"><code class="literal">sqltypelen</code><br /></span><span class="term"><code class="literal">sqlownerlen</code><br /></span><span class="term"><code class="literal">sqlsourcetype</code><br /></span><span class="term"><code class="literal">sqlownername</code><br /></span><span class="term"><code class="literal">sqlsourceid</code><br /></span><span class="term"><code class="literal">sqlflags</code><br /></span><span class="term"><code class="literal">sqlreserved</code></span> <a href="#ECPG-INFORMIX-SQLDA-SQLTYPENAME" class="id_link">#</a></dt><dd><p>
Unused.
</p></dd><dt id="ECPG-INFORMIX-SQLDA-SQLILONGDATA"><span class="term"><code class="literal">sqlilongdata</code></span> <a href="#ECPG-INFORMIX-SQLDA-SQLILONGDATA" class="id_link">#</a></dt><dd><p>
It equals to <code class="literal">sqldata</code> if <code class="literal">sqllen</code> is larger than 32kB.
</p></dd></dl></div><p>
Example:
</p><pre class="programlisting">
EXEC SQL INCLUDE sqlda.h;
sqlda_t *sqlda; /* This doesn't need to be under embedded DECLARE SECTION */
EXEC SQL BEGIN DECLARE SECTION;
char *prep_stmt = "select * from table1";
int i;
EXEC SQL END DECLARE SECTION;
...
EXEC SQL PREPARE mystmt FROM :prep_stmt;
EXEC SQL DESCRIBE mystmt INTO sqlda;
printf("# of fields: %d\n", sqlda->sqld);
for (i = 0; i < sqlda->sqld; i++)
printf("field %d: \"%s\"\n", sqlda->sqlvar[i]->sqlname);
EXEC SQL DECLARE mycursor CURSOR FOR mystmt;
EXEC SQL OPEN mycursor;
EXEC SQL WHENEVER NOT FOUND GOTO out;
while (1)
{
EXEC SQL FETCH mycursor USING sqlda;
}
EXEC SQL CLOSE mycursor;
free(sqlda); /* The main structure is all to be free(),
* sqlda and sqlda->sqlvar is in one allocated area */
</pre><p>
For more information, see the <code class="literal">sqlda.h</code> header and the
<code class="literal">src/interfaces/ecpg/test/compat_informix/sqlda.pgc</code> regression test.
</p></div><div class="sect2" id="ECPG-INFORMIX-FUNCTIONS"><div class="titlepage"><div><div><h3 class="title">36.15.4. Additional Functions <a href="#ECPG-INFORMIX-FUNCTIONS" class="id_link">#</a></h3></div></div></div><p>
</p><div class="variablelist"><dl class="variablelist"><dt id="ECPG-INFORMIX-FUNCTIONS-DECADD"><span class="term"><code class="function">decadd</code></span> <a href="#ECPG-INFORMIX-FUNCTIONS-DECADD" class="id_link">#</a></dt><dd><p>
Add two decimal type values.
</p><pre class="synopsis">
int decadd(decimal *arg1, decimal *arg2, decimal *sum);
</pre><p>
The function receives a pointer to the first operand of type decimal
(<code class="literal">arg1</code>), a pointer to the second operand of type decimal
(<code class="literal">arg2</code>) and a pointer to a value of type decimal that will
contain the sum (<code class="literal">sum</code>). On success, the function returns 0.
<code class="symbol">ECPG_INFORMIX_NUM_OVERFLOW</code> is returned in case of overflow and
<code class="symbol">ECPG_INFORMIX_NUM_UNDERFLOW</code> in case of underflow. -1 is returned for
other failures and <code class="varname">errno</code> is set to the respective <code class="varname">errno</code> number of the
pgtypeslib.
</p></dd><dt id="ECPG-INFORMIX-FUNCTIONS-DECCMP"><span class="term"><code class="function">deccmp</code></span> <a href="#ECPG-INFORMIX-FUNCTIONS-DECCMP" class="id_link">#</a></dt><dd><p>
Compare two variables of type decimal.
</p><pre class="synopsis">
int deccmp(decimal *arg1, decimal *arg2);
</pre><p>
The function receives a pointer to the first decimal value
(<code class="literal">arg1</code>), a pointer to the second decimal value
(<code class="literal">arg2</code>) and returns an integer value that indicates which is
the bigger value.
</p><div class="itemizedlist"><ul class="itemizedlist" style="list-style-type: disc; "><li class="listitem"><p>
1, if the value that <code class="literal">arg1</code> points to is bigger than the
value that <code class="literal">var2</code> points to
</p></li><li class="listitem"><p>
-1, if the value that <code class="literal">arg1</code> points to is smaller than the
value that <code class="literal">arg2</code> points to </p></li><li class="listitem"><p>
0, if the value that <code class="literal">arg1</code> points to and the value that
<code class="literal">arg2</code> points to are equal
</p></li></ul></div><p>
</p></dd><dt id="ECPG-INFORMIX-FUNCTIONS-DECCOPY"><span class="term"><code class="function">deccopy</code></span> <a href="#ECPG-INFORMIX-FUNCTIONS-DECCOPY" class="id_link">#</a></dt><dd><p>
Copy a decimal value.
</p><pre class="synopsis">
void deccopy(decimal *src, decimal *target);
</pre><p>
The function receives a pointer to the decimal value that should be
copied as the first argument (<code class="literal">src</code>) and a pointer to the
target structure of type decimal (<code class="literal">target</code>) as the second
argument.
</p></dd><dt id="ECPG-INFORMIX-FUNCTIONS-DECCVASC"><span class="term"><code class="function">deccvasc</code></span> <a href="#ECPG-INFORMIX-FUNCTIONS-DECCVASC" class="id_link">#</a></dt><dd><p>
Convert a value from its ASCII representation into a decimal type.
</p><pre class="synopsis">
int deccvasc(char *cp, int len, decimal *np);
</pre><p>
The function receives a pointer to string that contains the string
representation of the number to be converted (<code class="literal">cp</code>) as well
as its length <code class="literal">len</code>. <code class="literal">np</code> is a pointer to the
decimal value that saves the result of the operation.
</p><p>
Valid formats are for example:
<code class="literal">-2</code>,
<code class="literal">.794</code>,
<code class="literal">+3.44</code>,
<code class="literal">592.49E07</code> or
<code class="literal">-32.84e-4</code>.
</p><p>
The function returns 0 on success. If overflow or underflow occurred,
<code class="literal">ECPG_INFORMIX_NUM_OVERFLOW</code> or
<code class="literal">ECPG_INFORMIX_NUM_UNDERFLOW</code> is returned. If the ASCII
representation could not be parsed,
<code class="literal">ECPG_INFORMIX_BAD_NUMERIC</code> is returned or
<code class="literal">ECPG_INFORMIX_BAD_EXPONENT</code> if this problem occurred while
parsing the exponent.
</p></dd><dt id="ECPG-INFORMIX-FUNCTIONS-DECCVDBL"><span class="term"><code class="function">deccvdbl</code></span> <a href="#ECPG-INFORMIX-FUNCTIONS-DECCVDBL" class="id_link">#</a></dt><dd><p>
Convert a value of type double to a value of type decimal.
</p><pre class="synopsis">
int deccvdbl(double dbl, decimal *np);
</pre><p>
The function receives the variable of type double that should be
converted as its first argument (<code class="literal">dbl</code>). As the second
argument (<code class="literal">np</code>), the function receives a pointer to the
decimal variable that should hold the result of the operation.
</p><p>
The function returns 0 on success and a negative value if the
conversion failed.
</p></dd><dt id="ECPG-INFORMIX-FUNCTIONS-DECCVINT"><span class="term"><code class="function">deccvint</code></span> <a href="#ECPG-INFORMIX-FUNCTIONS-DECCVINT" class="id_link">#</a></dt><dd><p>
Convert a value of type int to a value of type decimal.
</p><pre class="synopsis">
int deccvint(int in, decimal *np);
</pre><p>
The function receives the variable of type int that should be
converted as its first argument (<code class="literal">in</code>). As the second
argument (<code class="literal">np</code>), the function receives a pointer to the
decimal variable that should hold the result of the operation.
</p><p>
The function returns 0 on success and a negative value if the
conversion failed.
</p></dd><dt id="ECPG-INFORMIX-FUNCTIONS-DECCVLONG"><span class="term"><code class="function">deccvlong</code></span> <a href="#ECPG-INFORMIX-FUNCTIONS-DECCVLONG" class="id_link">#</a></dt><dd><p>
Convert a value of type long to a value of type decimal.
</p><pre class="synopsis">
int deccvlong(long lng, decimal *np);
</pre><p>
The function receives the variable of type long that should be
converted as its first argument (<code class="literal">lng</code>). As the second
argument (<code class="literal">np</code>), the function receives a pointer to the
decimal variable that should hold the result of the operation.
</p><p>
The function returns 0 on success and a negative value if the
conversion failed.
</p></dd><dt id="ECPG-INFORMIX-FUNCTIONS-DECDIV"><span class="term"><code class="function">decdiv</code></span> <a href="#ECPG-INFORMIX-FUNCTIONS-DECDIV" class="id_link">#</a></dt><dd><p>
Divide two variables of type decimal.
</p><pre class="synopsis">
int decdiv(decimal *n1, decimal *n2, decimal *result);
</pre><p>
The function receives pointers to the variables that are the first
(<code class="literal">n1</code>) and the second (<code class="literal">n2</code>) operands and
calculates <code class="literal">n1</code>/<code class="literal">n2</code>. <code class="literal">result</code> is a
pointer to the variable that should hold the result of the operation.
</p><p>
On success, 0 is returned and a negative value if the division fails.
If overflow or underflow occurred, the function returns
<code class="literal">ECPG_INFORMIX_NUM_OVERFLOW</code> or
<code class="literal">ECPG_INFORMIX_NUM_UNDERFLOW</code> respectively. If an attempt to
divide by zero is observed, the function returns
<code class="literal">ECPG_INFORMIX_DIVIDE_ZERO</code>.
</p></dd><dt id="ECPG-INFORMIX-FUNCTIONS-DECMUL"><span class="term"><code class="function">decmul</code></span> <a href="#ECPG-INFORMIX-FUNCTIONS-DECMUL" class="id_link">#</a></dt><dd><p>
Multiply two decimal values.
</p><pre class="synopsis">
int decmul(decimal *n1, decimal *n2, decimal *result);
</pre><p>
The function receives pointers to the variables that are the first
(<code class="literal">n1</code>) and the second (<code class="literal">n2</code>) operands and
calculates <code class="literal">n1</code>*<code class="literal">n2</code>. <code class="literal">result</code> is a
pointer to the variable that should hold the result of the operation.
</p><p>
On success, 0 is returned and a negative value if the multiplication
fails. If overflow or underflow occurred, the function returns
<code class="literal">ECPG_INFORMIX_NUM_OVERFLOW</code> or
<code class="literal">ECPG_INFORMIX_NUM_UNDERFLOW</code> respectively.
</p></dd><dt id="ECPG-INFORMIX-FUNCTIONS-DECSUB"><span class="term"><code class="function">decsub</code></span> <a href="#ECPG-INFORMIX-FUNCTIONS-DECSUB" class="id_link">#</a></dt><dd><p>
Subtract one decimal value from another.
</p><pre class="synopsis">
int decsub(decimal *n1, decimal *n2, decimal *result);
</pre><p>
The function receives pointers to the variables that are the first
(<code class="literal">n1</code>) and the second (<code class="literal">n2</code>) operands and
calculates <code class="literal">n1</code>-<code class="literal">n2</code>. <code class="literal">result</code> is a
pointer to the variable that should hold the result of the operation.
</p><p>
On success, 0 is returned and a negative value if the subtraction
fails. If overflow or underflow occurred, the function returns
<code class="literal">ECPG_INFORMIX_NUM_OVERFLOW</code> or
<code class="literal">ECPG_INFORMIX_NUM_UNDERFLOW</code> respectively.
</p></dd><dt id="ECPG-INFORMIX-FUNCTIONS-DECTOASC"><span class="term"><code class="function">dectoasc</code></span> <a href="#ECPG-INFORMIX-FUNCTIONS-DECTOASC" class="id_link">#</a></dt><dd><p>
Convert a variable of type decimal to its ASCII representation in a C
char* string.
</p><pre class="synopsis">
int dectoasc(decimal *np, char *cp, int len, int right)
</pre><p>
The function receives a pointer to a variable of type decimal
(<code class="literal">np</code>) that it converts to its textual representation.
<code class="literal">cp</code> is the buffer that should hold the result of the
operation. The parameter <code class="literal">right</code> specifies, how many digits
right of the decimal point should be included in the output. The result
will be rounded to this number of decimal digits. Setting
<code class="literal">right</code> to -1 indicates that all available decimal digits
should be included in the output. If the length of the output buffer,
which is indicated by <code class="literal">len</code> is not sufficient to hold the
textual representation including the trailing zero byte, only a
single <code class="literal">*</code> character is stored in the result and -1 is
returned.
</p><p>
The function returns either -1 if the buffer <code class="literal">cp</code> was too
small or <code class="literal">ECPG_INFORMIX_OUT_OF_MEMORY</code> if memory was
exhausted.
</p></dd><dt id="ECPG-INFORMIX-FUNCTIONS-DECTODBL"><span class="term"><code class="function">dectodbl</code></span> <a href="#ECPG-INFORMIX-FUNCTIONS-DECTODBL" class="id_link">#</a></dt><dd><p>
Convert a variable of type decimal to a double.
</p><pre class="synopsis">
int dectodbl(decimal *np, double *dblp);
</pre><p>
The function receives a pointer to the decimal value to convert
(<code class="literal">np</code>) and a pointer to the double variable that
should hold the result of the operation (<code class="literal">dblp</code>).
</p><p>
On success, 0 is returned and a negative value if the conversion
failed.
</p></dd><dt id="ECPG-INFORMIX-FUNCTIONS-DECTOINT"><span class="term"><code class="function">dectoint</code></span> <a href="#ECPG-INFORMIX-FUNCTIONS-DECTOINT" class="id_link">#</a></dt><dd><p>
Convert a variable to type decimal to an integer.
</p><pre class="synopsis">
int dectoint(decimal *np, int *ip);
</pre><p>
The function receives a pointer to the decimal value to convert
(<code class="literal">np</code>) and a pointer to the integer variable that
should hold the result of the operation (<code class="literal">ip</code>).
</p><p>
On success, 0 is returned and a negative value if the conversion
failed. If an overflow occurred, <code class="literal">ECPG_INFORMIX_NUM_OVERFLOW</code>
is returned.
</p><p>
Note that the ECPG implementation differs from the <span class="productname">Informix</span>
implementation. <span class="productname">Informix</span> limits an integer to the range from -32767 to
32767, while the limits in the ECPG implementation depend on the
architecture (<code class="literal">INT_MIN .. INT_MAX</code>).
</p></dd><dt id="ECPG-INFORMIX-FUNCTIONS-DECTOLONG"><span class="term"><code class="function">dectolong</code></span> <a href="#ECPG-INFORMIX-FUNCTIONS-DECTOLONG" class="id_link">#</a></dt><dd><p>
Convert a variable to type decimal to a long integer.
</p><pre class="synopsis">
int dectolong(decimal *np, long *lngp);
</pre><p>
The function receives a pointer to the decimal value to convert
(<code class="literal">np</code>) and a pointer to the long variable that
should hold the result of the operation (<code class="literal">lngp</code>).
</p><p>
On success, 0 is returned and a negative value if the conversion
failed. If an overflow occurred, <code class="literal">ECPG_INFORMIX_NUM_OVERFLOW</code>
is returned.
</p><p>
Note that the ECPG implementation differs from the <span class="productname">Informix</span>
implementation. <span class="productname">Informix</span> limits a long integer to the range from
-2,147,483,647 to 2,147,483,647, while the limits in the ECPG
implementation depend on the architecture (<code class="literal">-LONG_MAX ..
LONG_MAX</code>).
</p></dd><dt id="ECPG-INFORMIX-FUNCTIONS-RDATESTR"><span class="term"><code class="function">rdatestr</code></span> <a href="#ECPG-INFORMIX-FUNCTIONS-RDATESTR" class="id_link">#</a></dt><dd><p>
Converts a date to a C char* string.
</p><pre class="synopsis">
int rdatestr(date d, char *str);
</pre><p>
The function receives two arguments, the first one is the date to
convert (<code class="literal">d</code>) and the second one is a pointer to the target
string. The output format is always <code class="literal">yyyy-mm-dd</code>, so you need
to allocate at least 11 bytes (including the zero-byte terminator) for the
string.
</p><p>
The function returns 0 on success and a negative value in case of
error.
</p><p>
Note that ECPG's implementation differs from the <span class="productname">Informix</span>
implementation. In <span class="productname">Informix</span> the format can be influenced by setting
environment variables. In ECPG however, you cannot change the output
format.
</p></dd><dt id="ECPG-INFORMIX-FUNCTIONS-RSTRDATE"><span class="term"><code class="function">rstrdate</code></span> <a href="#ECPG-INFORMIX-FUNCTIONS-RSTRDATE" class="id_link">#</a></dt><dd><p>
Parse the textual representation of a date.
</p><pre class="synopsis">
int rstrdate(char *str, date *d);
</pre><p>
The function receives the textual representation of the date to convert
(<code class="literal">str</code>) and a pointer to a variable of type date
(<code class="literal">d</code>). This function does not allow you to specify a format
mask. It uses the default format mask of <span class="productname">Informix</span> which is
<code class="literal">mm/dd/yyyy</code>. Internally, this function is implemented by
means of <code class="function">rdefmtdate</code>. Therefore, <code class="function">rstrdate</code> is
not faster and if you have the choice you should opt for
<code class="function">rdefmtdate</code> which allows you to specify the format mask
explicitly.
</p><p>
The function returns the same values as <code class="function">rdefmtdate</code>.
</p></dd><dt id="ECPG-INFORMIX-FUNCTIONS-RTODAY"><span class="term"><code class="function">rtoday</code></span> <a href="#ECPG-INFORMIX-FUNCTIONS-RTODAY" class="id_link">#</a></dt><dd><p>
Get the current date.
</p><pre class="synopsis">
void rtoday(date *d);
</pre><p>
The function receives a pointer to a date variable (<code class="literal">d</code>)
that it sets to the current date.
</p><p>
Internally this function uses the <a class="xref" href="ecpg-pgtypes.html#PGTYPESDATETODAY"><code class="function">PGTYPESdate_today</code></a>
function.
</p></dd><dt id="ECPG-INFORMIX-FUNCTIONS-RJULMDY"><span class="term"><code class="function">rjulmdy</code></span> <a href="#ECPG-INFORMIX-FUNCTIONS-RJULMDY" class="id_link">#</a></dt><dd><p>
Extract the values for the day, the month and the year from a variable
of type date.
</p><pre class="synopsis">
int rjulmdy(date d, short mdy[3]);
</pre><p>
The function receives the date <code class="literal">d</code> and a pointer to an array
of 3 short integer values <code class="literal">mdy</code>. The variable name indicates
the sequential order: <code class="literal">mdy[0]</code> will be set to contain the
number of the month, <code class="literal">mdy[1]</code> will be set to the value of the
day and <code class="literal">mdy[2]</code> will contain the year.
</p><p>
The function always returns 0 at the moment.
</p><p>
Internally the function uses the <a class="xref" href="ecpg-pgtypes.html#PGTYPESDATEJULMDY"><code class="function">PGTYPESdate_julmdy</code></a>
function.
</p></dd><dt id="ECPG-INFORMIX-FUNCTIONS-RDEFMTDATE"><span class="term"><code class="function">rdefmtdate</code></span> <a href="#ECPG-INFORMIX-FUNCTIONS-RDEFMTDATE" class="id_link">#</a></dt><dd><p>
Use a format mask to convert a character string to a value of type
date.
</p><pre class="synopsis">
int rdefmtdate(date *d, char *fmt, char *str);
</pre><p>
The function receives a pointer to the date value that should hold the
result of the operation (<code class="literal">d</code>), the format mask to use for
parsing the date (<code class="literal">fmt</code>) and the C char* string containing
the textual representation of the date (<code class="literal">str</code>). The textual
representation is expected to match the format mask. However you do not
need to have a 1:1 mapping of the string to the format mask. The
function only analyzes the sequential order and looks for the literals
<code class="literal">yy</code> or <code class="literal">yyyy</code> that indicate the
position of the year, <code class="literal">mm</code> to indicate the position of
the month and <code class="literal">dd</code> to indicate the position of the
day.
</p><p>
The function returns the following values:
</p><div class="itemizedlist"><ul class="itemizedlist" style="list-style-type: disc; "><li class="listitem"><p>
0 - The function terminated successfully.
</p></li><li class="listitem"><p>
<code class="literal">ECPG_INFORMIX_ENOSHORTDATE</code> - The date does not contain
delimiters between day, month and year. In this case the input
string must be exactly 6 or 8 bytes long but isn't.
</p></li><li class="listitem"><p>
<code class="literal">ECPG_INFORMIX_ENOTDMY</code> - The format string did not
correctly indicate the sequential order of year, month and day.
</p></li><li class="listitem"><p>
<code class="literal">ECPG_INFORMIX_BAD_DAY</code> - The input string does not
contain a valid day.
</p></li><li class="listitem"><p>
<code class="literal">ECPG_INFORMIX_BAD_MONTH</code> - The input string does not
contain a valid month.
</p></li><li class="listitem"><p>
<code class="literal">ECPG_INFORMIX_BAD_YEAR</code> - The input string does not
contain a valid year.
</p></li></ul></div><p>
</p><p>
Internally this function is implemented to use the <a class="xref" href="ecpg-pgtypes.html#PGTYPESDATEDEFMTASC"><code class="function">PGTYPESdate_defmt_asc</code></a> function. See the reference there for a
table of example input.
</p></dd><dt id="ECPG-INFORMIX-FUNCTIONS-RFMTDATE"><span class="term"><code class="function">rfmtdate</code></span> <a href="#ECPG-INFORMIX-FUNCTIONS-RFMTDATE" class="id_link">#</a></dt><dd><p>
Convert a variable of type date to its textual representation using a
format mask.
</p><pre class="synopsis">
int rfmtdate(date d, char *fmt, char *str);
</pre><p>
The function receives the date to convert (<code class="literal">d</code>), the format
mask (<code class="literal">fmt</code>) and the string that will hold the textual
representation of the date (<code class="literal">str</code>).
</p><p>
On success, 0 is returned and a negative value if an error occurred.
</p><p>
Internally this function uses the <a class="xref" href="ecpg-pgtypes.html#PGTYPESDATEFMTASC"><code class="function">PGTYPESdate_fmt_asc</code></a>
function, see the reference there for examples.
</p></dd><dt id="ECPG-INFORMIX-FUNCTIONS-RMDYJUL"><span class="term"><code class="function">rmdyjul</code></span> <a href="#ECPG-INFORMIX-FUNCTIONS-RMDYJUL" class="id_link">#</a></dt><dd><p>
Create a date value from an array of 3 short integers that specify the
day, the month and the year of the date.
</p><pre class="synopsis">
int rmdyjul(short mdy[3], date *d);
</pre><p>
The function receives the array of the 3 short integers
(<code class="literal">mdy</code>) and a pointer to a variable of type date that should
hold the result of the operation.
</p><p>
Currently the function returns always 0.
</p><p>
Internally the function is implemented to use the function <a class="xref" href="ecpg-pgtypes.html#PGTYPESDATEMDYJUL"><code class="function">PGTYPESdate_mdyjul</code></a>.
</p></dd><dt id="ECPG-INFORMIX-FUNCTIONS-RDAYOFWEEK"><span class="term"><code class="function">rdayofweek</code></span> <a href="#ECPG-INFORMIX-FUNCTIONS-RDAYOFWEEK" class="id_link">#</a></dt><dd><p>
Return a number representing the day of the week for a date value.
</p><pre class="synopsis">
int rdayofweek(date d);
</pre><p>
The function receives the date variable <code class="literal">d</code> as its only
argument and returns an integer that indicates the day of the week for
this date.
</p><div class="itemizedlist"><ul class="itemizedlist" style="list-style-type: disc; "><li class="listitem"><p>
0 - Sunday
</p></li><li class="listitem"><p>
1 - Monday
</p></li><li class="listitem"><p>
2 - Tuesday
</p></li><li class="listitem"><p>
3 - Wednesday
</p></li><li class="listitem"><p>
4 - Thursday
</p></li><li class="listitem"><p>
5 - Friday
</p></li><li class="listitem"><p>
6 - Saturday
</p></li></ul></div><p>
</p><p>
Internally the function is implemented to use the function <a class="xref" href="ecpg-pgtypes.html#PGTYPESDATEDAYOFWEEK"><code class="function">PGTYPESdate_dayofweek</code></a>.
</p></dd><dt id="ECPG-INFORMIX-FUNCTIONS-DTCURRENT"><span class="term"><code class="function">dtcurrent</code></span> <a href="#ECPG-INFORMIX-FUNCTIONS-DTCURRENT" class="id_link">#</a></dt><dd><p>
Retrieve the current timestamp.
</p><pre class="synopsis">
void dtcurrent(timestamp *ts);
</pre><p>
The function retrieves the current timestamp and saves it into the
timestamp variable that <code class="literal">ts</code> points to.
</p></dd><dt id="ECPG-INFORMIX-FUNCTIONS-DTCVASC"><span class="term"><code class="function">dtcvasc</code></span> <a href="#ECPG-INFORMIX-FUNCTIONS-DTCVASC" class="id_link">#</a></dt><dd><p>
Parses a timestamp from its textual representation
into a timestamp variable.
</p><pre class="synopsis">
int dtcvasc(char *str, timestamp *ts);
</pre><p>
The function receives the string to parse (<code class="literal">str</code>) and a
pointer to the timestamp variable that should hold the result of the
operation (<code class="literal">ts</code>).
</p><p>
The function returns 0 on success and a negative value in case of
error.
</p><p>
Internally this function uses the <a class="xref" href="ecpg-pgtypes.html#PGTYPESTIMESTAMPFROMASC"><code class="function">PGTYPEStimestamp_from_asc</code></a> function. See the reference there
for a table with example inputs.
</p></dd><dt id="ECPG-INFORMIX-FUNCTIONS-DTCVFMTASC"><span class="term"><code class="function">dtcvfmtasc</code></span> <a href="#ECPG-INFORMIX-FUNCTIONS-DTCVFMTASC" class="id_link">#</a></dt><dd><p>
Parses a timestamp from its textual representation
using a format mask into a timestamp variable.
</p><pre class="synopsis">
dtcvfmtasc(char *inbuf, char *fmtstr, timestamp *dtvalue)
</pre><p>
The function receives the string to parse (<code class="literal">inbuf</code>), the
format mask to use (<code class="literal">fmtstr</code>) and a pointer to the timestamp
variable that should hold the result of the operation
(<code class="literal">dtvalue</code>).
</p><p>
This function is implemented by means of the <a class="xref" href="ecpg-pgtypes.html#PGTYPESTIMESTAMPDEFMTASC"><code class="function">PGTYPEStimestamp_defmt_asc</code></a> function. See the documentation
there for a list of format specifiers that can be used.
</p><p>
The function returns 0 on success and a negative value in case of
error.
</p></dd><dt id="ECPG-INFORMIX-FUNCTIONS-DTSUB"><span class="term"><code class="function">dtsub</code></span> <a href="#ECPG-INFORMIX-FUNCTIONS-DTSUB" class="id_link">#</a></dt><dd><p>
Subtract one timestamp from another and return a variable of type
interval.
</p><pre class="synopsis">
int dtsub(timestamp *ts1, timestamp *ts2, interval *iv);
</pre><p>
The function will subtract the timestamp variable that <code class="literal">ts2</code>
points to from the timestamp variable that <code class="literal">ts1</code> points to
and will store the result in the interval variable that <code class="literal">iv</code>
points to.
</p><p>
Upon success, the function returns 0 and a negative value if an
error occurred.
</p></dd><dt id="ECPG-INFORMIX-FUNCTIONS-DTTOASC"><span class="term"><code class="function">dttoasc</code></span> <a href="#ECPG-INFORMIX-FUNCTIONS-DTTOASC" class="id_link">#</a></dt><dd><p>
Convert a timestamp variable to a C char* string.
</p><pre class="synopsis">
int dttoasc(timestamp *ts, char *output);
</pre><p>
The function receives a pointer to the timestamp variable to convert
(<code class="literal">ts</code>) and the string that should hold the result of the
operation (<code class="literal">output</code>). It converts <code class="literal">ts</code> to its
textual representation according to the SQL standard, which is
be <code class="literal">YYYY-MM-DD HH:MM:SS</code>.
</p><p>
Upon success, the function returns 0 and a negative value if an
error occurred.
</p></dd><dt id="ECPG-INFORMIX-FUNCTIONS-DTTOFMTASC"><span class="term"><code class="function">dttofmtasc</code></span> <a href="#ECPG-INFORMIX-FUNCTIONS-DTTOFMTASC" class="id_link">#</a></dt><dd><p>
Convert a timestamp variable to a C char* using a format mask.
</p><pre class="synopsis">
int dttofmtasc(timestamp *ts, char *output, int str_len, char *fmtstr);
</pre><p>
The function receives a pointer to the timestamp to convert as its
first argument (<code class="literal">ts</code>), a pointer to the output buffer
(<code class="literal">output</code>), the maximal length that has been allocated for
the output buffer (<code class="literal">str_len</code>) and the format mask to
use for the conversion (<code class="literal">fmtstr</code>).
</p><p>
Upon success, the function returns 0 and a negative value if an
error occurred.
</p><p>
Internally, this function uses the <a class="xref" href="ecpg-pgtypes.html#PGTYPESTIMESTAMPFMTASC"><code class="function">PGTYPEStimestamp_fmt_asc</code></a> function. See the reference there for
information on what format mask specifiers can be used.
</p></dd><dt id="ECPG-INFORMIX-FUNCTIONS-INTOASC"><span class="term"><code class="function">intoasc</code></span> <a href="#ECPG-INFORMIX-FUNCTIONS-INTOASC" class="id_link">#</a></dt><dd><p>
Convert an interval variable to a C char* string.
</p><pre class="synopsis">
int intoasc(interval *i, char *str);
</pre><p>
The function receives a pointer to the interval variable to convert
(<code class="literal">i</code>) and the string that should hold the result of the
operation (<code class="literal">str</code>). It converts <code class="literal">i</code> to its
textual representation according to the SQL standard, which is
be <code class="literal">YYYY-MM-DD HH:MM:SS</code>.
</p><p>
Upon success, the function returns 0 and a negative value if an
error occurred.
</p></dd><dt id="ECPG-INFORMIX-FUNCTIONS-RFMTLONG"><span class="term"><code class="function">rfmtlong</code></span> <a href="#ECPG-INFORMIX-FUNCTIONS-RFMTLONG" class="id_link">#</a></dt><dd><p>
Convert a long integer value to its textual representation using a
format mask.
</p><pre class="synopsis">
int rfmtlong(long lng_val, char *fmt, char *outbuf);
</pre><p>
The function receives the long value <code class="literal">lng_val</code>, the format
mask <code class="literal">fmt</code> and a pointer to the output buffer
<code class="literal">outbuf</code>. It converts the long value according to the format
mask to its textual representation.
</p><p>
The format mask can be composed of the following format specifying
characters:
</p><div class="itemizedlist"><ul class="itemizedlist" style="list-style-type: disc; "><li class="listitem"><p>
<code class="literal">*</code> (asterisk) - if this position would be blank
otherwise, fill it with an asterisk.
</p></li><li class="listitem"><p>
<code class="literal">&</code> (ampersand) - if this position would be
blank otherwise, fill it with a zero.
</p></li><li class="listitem"><p>
<code class="literal">#</code> - turn leading zeroes into blanks.
</p></li><li class="listitem"><p>
<code class="literal"><</code> - left-justify the number in the string.
</p></li><li class="listitem"><p>
<code class="literal">,</code> (comma) - group numbers of four or more digits
into groups of three digits separated by a comma.
</p></li><li class="listitem"><p>
<code class="literal">.</code> (period) - this character separates the
whole-number part of the number from the fractional part.
</p></li><li class="listitem"><p>
<code class="literal">-</code> (minus) - the minus sign appears if the number
is a negative value.
</p></li><li class="listitem"><p>
<code class="literal">+</code> (plus) - the plus sign appears if the number is
a positive value.
</p></li><li class="listitem"><p>
<code class="literal">(</code> - this replaces the minus sign in front of the
negative number. The minus sign will not appear.
</p></li><li class="listitem"><p>
<code class="literal">)</code> - this character replaces the minus and is
printed behind the negative value.
</p></li><li class="listitem"><p>
<code class="literal">$</code> - the currency symbol.
</p></li></ul></div><p>
</p></dd><dt id="ECPG-INFORMIX-FUNCTIONS-RUPSHIFT"><span class="term"><code class="function">rupshift</code></span> <a href="#ECPG-INFORMIX-FUNCTIONS-RUPSHIFT" class="id_link">#</a></dt><dd><p>
Convert a string to upper case.
</p><pre class="synopsis">
void rupshift(char *str);
</pre><p>
The function receives a pointer to the string and transforms every
lower case character to upper case.
</p></dd><dt id="ECPG-INFORMIX-FUNCTIONS-BYLENG"><span class="term"><code class="function">byleng</code></span> <a href="#ECPG-INFORMIX-FUNCTIONS-BYLENG" class="id_link">#</a></dt><dd><p>
Return the number of characters in a string without counting trailing
blanks.
</p><pre class="synopsis">
int byleng(char *str, int len);
</pre><p>
The function expects a fixed-length string as its first argument
(<code class="literal">str</code>) and its length as its second argument
(<code class="literal">len</code>). It returns the number of significant characters,
that is the length of the string without trailing blanks.
</p></dd><dt id="ECPG-INFORMIX-FUNCTIONS-LDCHAR"><span class="term"><code class="function">ldchar</code></span> <a href="#ECPG-INFORMIX-FUNCTIONS-LDCHAR" class="id_link">#</a></dt><dd><p>
Copy a fixed-length string into a null-terminated string.
</p><pre class="synopsis">
void ldchar(char *src, int len, char *dest);
</pre><p>
The function receives the fixed-length string to copy
(<code class="literal">src</code>), its length (<code class="literal">len</code>) and a pointer to the
destination memory (<code class="literal">dest</code>). Note that you need to reserve at
least <code class="literal">len+1</code> bytes for the string that <code class="literal">dest</code>
points to. The function copies at most <code class="literal">len</code> bytes to the new
location (less if the source string has trailing blanks) and adds the
null-terminator.
</p></dd><dt id="ECPG-INFORMIX-FUNCTIONS-RGETMSG"><span class="term"><code class="function">rgetmsg</code></span> <a href="#ECPG-INFORMIX-FUNCTIONS-RGETMSG" class="id_link">#</a></dt><dd><p>
</p><pre class="synopsis">
int rgetmsg(int msgnum, char *s, int maxsize);
</pre><p>
This function exists but is not implemented at the moment!
</p></dd><dt id="ECPG-INFORMIX-FUNCTIONS-RTYPALIGN"><span class="term"><code class="function">rtypalign</code></span> <a href="#ECPG-INFORMIX-FUNCTIONS-RTYPALIGN" class="id_link">#</a></dt><dd><p>
</p><pre class="synopsis">
int rtypalign(int offset, int type);
</pre><p>
This function exists but is not implemented at the moment!
</p></dd><dt id="ECPG-INFORMIX-FUNCTIONS-RTYPMSIZE"><span class="term"><code class="function">rtypmsize</code></span> <a href="#ECPG-INFORMIX-FUNCTIONS-RTYPMSIZE" class="id_link">#</a></dt><dd><p>
</p><pre class="synopsis">
int rtypmsize(int type, int len);
</pre><p>
This function exists but is not implemented at the moment!
</p></dd><dt id="ECPG-INFORMIX-FUNCTIONS-RTYPWIDTH"><span class="term"><code class="function">rtypwidth</code></span> <a href="#ECPG-INFORMIX-FUNCTIONS-RTYPWIDTH" class="id_link">#</a></dt><dd><p>
</p><pre class="synopsis">
int rtypwidth(int sqltype, int sqllen);
</pre><p>
This function exists but is not implemented at the moment!
</p></dd><dt id="RSETNULL"><span class="term"><code class="function">rsetnull</code></span> <a href="#RSETNULL" class="id_link">#</a></dt><dd><p>
Set a variable to NULL.
</p><pre class="synopsis">
int rsetnull(int t, char *ptr);
</pre><p>
The function receives an integer that indicates the type of the
variable and a pointer to the variable itself that is cast to a C
char* pointer.
</p><p>
The following types exist:
</p><div class="itemizedlist"><ul class="itemizedlist" style="list-style-type: disc; "><li class="listitem"><p>
<code class="literal">CCHARTYPE</code> - For a variable of type <code class="type">char</code> or <code class="type">char*</code>
</p></li><li class="listitem"><p>
<code class="literal">CSHORTTYPE</code> - For a variable of type <code class="type">short int</code>
</p></li><li class="listitem"><p>
<code class="literal">CINTTYPE</code> - For a variable of type <code class="type">int</code>
</p></li><li class="listitem"><p>
<code class="literal">CBOOLTYPE</code> - For a variable of type <code class="type">boolean</code>
</p></li><li class="listitem"><p>
<code class="literal">CFLOATTYPE</code> - For a variable of type <code class="type">float</code>
</p></li><li class="listitem"><p>
<code class="literal">CLONGTYPE</code> - For a variable of type <code class="type">long</code>
</p></li><li class="listitem"><p>
<code class="literal">CDOUBLETYPE</code> - For a variable of type <code class="type">double</code>
</p></li><li class="listitem"><p>
<code class="literal">CDECIMALTYPE</code> - For a variable of type <code class="type">decimal</code>
</p></li><li class="listitem"><p>
<code class="literal">CDATETYPE</code> - For a variable of type <code class="type">date</code>
</p></li><li class="listitem"><p>
<code class="literal">CDTIMETYPE</code> - For a variable of type <code class="type">timestamp</code>
</p></li></ul></div><p>
</p><p>
Here is an example of a call to this function:
</p><pre class="programlisting">
$char c[] = "abc ";
$short s = 17;
$int i = -74874;
rsetnull(CCHARTYPE, (char *) c);
rsetnull(CSHORTTYPE, (char *) &s);
rsetnull(CINTTYPE, (char *) &i);
</pre><p>
</p></dd><dt id="ECPG-INFORMIX-FUNCTIONS-RISNULL"><span class="term"><code class="function">risnull</code></span> <a href="#ECPG-INFORMIX-FUNCTIONS-RISNULL" class="id_link">#</a></dt><dd><p>
Test if a variable is NULL.
</p><pre class="synopsis">
int risnull(int t, char *ptr);
</pre><p>
The function receives the type of the variable to test (<code class="literal">t</code>)
as well a pointer to this variable (<code class="literal">ptr</code>). Note that the
latter needs to be cast to a char*. See the function <a class="xref" href="ecpg-informix-compat.html#RSETNULL"><code class="function">rsetnull</code></a> for a list of possible variable types.
</p><p>
Here is an example of how to use this function:
</p><pre class="programlisting">
$char c[] = "abc ";
$short s = 17;
$int i = -74874;
risnull(CCHARTYPE, (char *) c);
risnull(CSHORTTYPE, (char *) &s);
risnull(CINTTYPE, (char *) &i);
</pre><p>
</p></dd></dl></div><p>
</p></div><div class="sect2" id="ECPG-INFORMIX-CONSTANTS"><div class="titlepage"><div><div><h3 class="title">36.15.5. Additional Constants <a href="#ECPG-INFORMIX-CONSTANTS" class="id_link">#</a></h3></div></div></div><p>
Note that all constants here describe errors and all of them are defined
to represent negative values. In the descriptions of the different
constants you can also find the value that the constants represent in the
current implementation. However you should not rely on this number. You can
however rely on the fact all of them are defined to represent negative
values.
</p><div class="variablelist"><dl class="variablelist"><dt id="ECPG-INFORMIX-CONSTANTS-ECPG-INFORMIX-NUM-OVERFLOW"><span class="term"><code class="literal">ECPG_INFORMIX_NUM_OVERFLOW</code></span> <a href="#ECPG-INFORMIX-CONSTANTS-ECPG-INFORMIX-NUM-OVERFLOW" class="id_link">#</a></dt><dd><p>
Functions return this value if an overflow occurred in a
calculation. Internally it is defined as -1200 (the <span class="productname">Informix</span>
definition).
</p></dd><dt id="ECPG-INFORMIX-CONSTANTS-ECPG-INFORMIX-NUM-UNDERFLOW"><span class="term"><code class="literal">ECPG_INFORMIX_NUM_UNDERFLOW</code></span> <a href="#ECPG-INFORMIX-CONSTANTS-ECPG-INFORMIX-NUM-UNDERFLOW" class="id_link">#</a></dt><dd><p>
Functions return this value if an underflow occurred in a calculation.
Internally it is defined as -1201 (the <span class="productname">Informix</span> definition).
</p></dd><dt id="ECPG-INFORMIX-CONSTANTS-ECPG-INFORMIX-DIVIDE-ZERO"><span class="term"><code class="literal">ECPG_INFORMIX_DIVIDE_ZERO</code></span> <a href="#ECPG-INFORMIX-CONSTANTS-ECPG-INFORMIX-DIVIDE-ZERO" class="id_link">#</a></dt><dd><p>
Functions return this value if an attempt to divide by zero is
observed. Internally it is defined as -1202 (the <span class="productname">Informix</span> definition).
</p></dd><dt id="ECPG-INFORMIX-CONSTANTS-ECPG-INFORMIX-BAD-YEAR"><span class="term"><code class="literal">ECPG_INFORMIX_BAD_YEAR</code></span> <a href="#ECPG-INFORMIX-CONSTANTS-ECPG-INFORMIX-BAD-YEAR" class="id_link">#</a></dt><dd><p>
Functions return this value if a bad value for a year was found while
parsing a date. Internally it is defined as -1204 (the <span class="productname">Informix</span>
definition).
</p></dd><dt id="ECPG-INFORMIX-CONSTANTS-ECPG-INFORMIX-BAD-MONTH"><span class="term"><code class="literal">ECPG_INFORMIX_BAD_MONTH</code></span> <a href="#ECPG-INFORMIX-CONSTANTS-ECPG-INFORMIX-BAD-MONTH" class="id_link">#</a></dt><dd><p>
Functions return this value if a bad value for a month was found while
parsing a date. Internally it is defined as -1205 (the <span class="productname">Informix</span>
definition).
</p></dd><dt id="ECPG-INFORMIX-CONSTANTS-ECPG-INFORMIX-BAD-DAY"><span class="term"><code class="literal">ECPG_INFORMIX_BAD_DAY</code></span> <a href="#ECPG-INFORMIX-CONSTANTS-ECPG-INFORMIX-BAD-DAY" class="id_link">#</a></dt><dd><p>
Functions return this value if a bad value for a day was found while
parsing a date. Internally it is defined as -1206 (the <span class="productname">Informix</span>
definition).
</p></dd><dt id="ECPG-INFORMIX-CONSTANTS-ECPG-INFORMIX-ENOSHORTDATE"><span class="term"><code class="literal">ECPG_INFORMIX_ENOSHORTDATE</code></span> <a href="#ECPG-INFORMIX-CONSTANTS-ECPG-INFORMIX-ENOSHORTDATE" class="id_link">#</a></dt><dd><p>
Functions return this value if a parsing routine needs a short date
representation but did not get the date string in the right length.
Internally it is defined as -1209 (the <span class="productname">Informix</span> definition).
</p></dd><dt id="ECPG-INFORMIX-CONSTANTS-ECPG-INFORMIX-DATE-CONVERT"><span class="term"><code class="literal">ECPG_INFORMIX_DATE_CONVERT</code></span> <a href="#ECPG-INFORMIX-CONSTANTS-ECPG-INFORMIX-DATE-CONVERT" class="id_link">#</a></dt><dd><p>
Functions return this value if an error occurred during date
formatting. Internally it is defined as -1210 (the
<span class="productname">Informix</span> definition).
</p></dd><dt id="ECPG-INFORMIX-CONSTANTS-ECPG-INFORMIX-OUT-OF-MEMORY"><span class="term"><code class="literal">ECPG_INFORMIX_OUT_OF_MEMORY</code></span> <a href="#ECPG-INFORMIX-CONSTANTS-ECPG-INFORMIX-OUT-OF-MEMORY" class="id_link">#</a></dt><dd><p>
Functions return this value if memory was exhausted during
their operation. Internally it is defined as -1211 (the
<span class="productname">Informix</span> definition).
</p></dd><dt id="ECPG-INFORMIX-CONSTANTS-ECPG-INFORMIX-ENOTDMY"><span class="term"><code class="literal">ECPG_INFORMIX_ENOTDMY</code></span> <a href="#ECPG-INFORMIX-CONSTANTS-ECPG-INFORMIX-ENOTDMY" class="id_link">#</a></dt><dd><p>
Functions return this value if a parsing routine was supposed to get a
format mask (like <code class="literal">mmddyy</code>) but not all fields were listed
correctly. Internally it is defined as -1212 (the <span class="productname">Informix</span> definition).
</p></dd><dt id="ECPG-INFORMIX-CONSTANTS-ECPG-INFORMIX-BAD-NUMERIC"><span class="term"><code class="literal">ECPG_INFORMIX_BAD_NUMERIC</code></span> <a href="#ECPG-INFORMIX-CONSTANTS-ECPG-INFORMIX-BAD-NUMERIC" class="id_link">#</a></dt><dd><p>
Functions return this value either if a parsing routine cannot parse
the textual representation for a numeric value because it contains
errors or if a routine cannot complete a calculation involving numeric
variables because at least one of the numeric variables is invalid.
Internally it is defined as -1213 (the <span class="productname">Informix</span> definition).
</p></dd><dt id="ECPG-INFORMIX-CONSTANTS-ECPG-INFORMIX-BAD-EXPONENT"><span class="term"><code class="literal">ECPG_INFORMIX_BAD_EXPONENT</code></span> <a href="#ECPG-INFORMIX-CONSTANTS-ECPG-INFORMIX-BAD-EXPONENT" class="id_link">#</a></dt><dd><p>
Functions return this value if a parsing routine cannot parse
an exponent. Internally it is defined as -1216 (the
<span class="productname">Informix</span> definition).
</p></dd><dt id="ECPG-INFORMIX-CONSTANTS-ECPG-INFORMIX-BAD-DATE"><span class="term"><code class="literal">ECPG_INFORMIX_BAD_DATE</code></span> <a href="#ECPG-INFORMIX-CONSTANTS-ECPG-INFORMIX-BAD-DATE" class="id_link">#</a></dt><dd><p>
Functions return this value if a parsing routine cannot parse
a date. Internally it is defined as -1218 (the
<span class="productname">Informix</span> definition).
</p></dd><dt id="ECPG-INFORMIX-CONSTANTS-ECPG-INFORMIX-EXTRA-CHARS"><span class="term"><code class="literal">ECPG_INFORMIX_EXTRA_CHARS</code></span> <a href="#ECPG-INFORMIX-CONSTANTS-ECPG-INFORMIX-EXTRA-CHARS" class="id_link">#</a></dt><dd><p>
Functions return this value if a parsing routine is passed extra
characters it cannot parse. Internally it is defined as -1264 (the
<span class="productname">Informix</span> definition).
</p></dd></dl></div><p>
</p></div></div><div class="navfooter"><hr /><table width="100%" summary="Navigation footer"><tr><td width="40%" align="left"><a accesskey="p" href="ecpg-sql-whenever.html" title="WHENEVER">Prev</a> </td><td width="20%" align="center"><a accesskey="u" href="ecpg.html" title="Chapter 36. ECPG — Embedded SQL in C">Up</a></td><td width="40%" align="right"> <a accesskey="n" href="ecpg-oracle-compat.html" title="36.16. Oracle Compatibility Mode">Next</a></td></tr><tr><td width="40%" align="left" valign="top">WHENEVER </td><td width="20%" align="center"><a accesskey="h" href="index.html" title="PostgreSQL 16.2 Documentation">Home</a></td><td width="40%" align="right" valign="top"> 36.16. <span class="productname">Oracle</span> Compatibility Mode</td></tr></table></div></body></html>
|
