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
|
Get_Variable("EUSER","ENV","USERNAME");
Message("Le Login Windows est : %EUSER%");
Get_Variable("st","JOB","FOLDER1.date_err.SYSTEM.STATUS");
AFFECT("filter1", '%%/"t"');
AFFECT("filter2", '%%/"pi"');
JSONTOSQL("%{jsonpath}%/file.json", "",
" JSONPATH like '%filter1%' ", "a = JSONVALUE",
" JSONPATH like '%filter2%' ", "b = JSONVALUE; output(json_data, a, b)");
GOTO("There");
/*
skipped
*/
:There;
Cursor("select * from IOUSER",,)
{
Message("%USR%");
}
/***
test
***/
Option("ESCAPE","True");
Affect('xsl','<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="xml" indent="yes" />
<xsl:template match="/">
<document>
<xsl:for-each select="root/set/row">
<xsl:element name="cmr"><xsl:attribute name="id"><xsl:value-of select="cell[1]/value"/></xsl:attribute>
<xsl:for-each select="cell">
<xsl:if test="name!=\'id_cmr\'">
<xsl:element name="{name}"><xsl:value-of select="value"/></xsl:element>
</xsl:if>
</xsl:for-each>
</xsl:element>
</xsl:for-each>
</document>
</xsl:template>
</xsl:stylesheet>');
Option("ESCAPE","False");
Rtf_Tab("C:\data\dev\rtf\rtf\fusion_tableaux.rtf","C:\data\dev\rtf\rtf\fusion_tableaux_res.rtf",
"TABLEAU1","select COL1,COL2,COL3 from TABLE_FUSIONRTF");
Affect(VAR1,'%TEST%'); //Créer et affecter la variable VAR1 avec une chaîne
select * from [TABLE1] where COL1 like %VAR1%; //utiliser la variable VAR1 dans une requête
select * from @DATAZONE1.TEST_TABLE; //exécution d'une requête Select pour ramener des valeurs
Affect_LastColumns("TEST1", 0, 0); //création du paramètre TEST1
Affect("xslt", '<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:template match="/">
<root>
<xsl:for-each select="root/set/row">
<tr>
<xsl:for-each select="cell">
<td><xsl:value-of select="name" />: <xsl:value-of select="value" /> (<xsl:value-of select="type" />)</td>
</xsl:for-each>
</tr>
</xsl:for-each>
</root>
</xsl:template>
</xsl:stylesheet>');
XSLT_MEM_SQL("out","select USRCODE, LOGONAT, NUMSESS from IOUSERS where rownum <= 2","%xslt%","CHARSET=ISO-8859-1");
Open_Sql("select *
from bar");
|
