![Nested stored procedure with dynamic result set returns errors [CR 401334]](arrow-right.gif){kind=icon}
When using Component Integration Services (CIS) in certain geographic regions, connection attempts return the error No Suitable Driver. Java Development Kits used with Sybase IQ 12.6 support only time zone codes shown in Table 5 and Table 6.
For databases using default JDK 1.1.8:
Substitute JST for unsupported time zone KST, which gives the same GMT+9 time, as follows:
setenv TZ JST
For databases using JDK 1.3:
setenv TZ Asia/Seoul
Set the time zone environment variable to a supported setting, start the server, and CIS works as expected. To ensure that the correct setting is always used, you can set the time zone in a star-up script such as .cshrc or .login.
See Table 5 and Table 6 for the appropriate time zone code and settings.
Time zone setting |
Time zone code |
Time zone setting |
Time zone code |
|---|---|---|---|
0 |
GMT |
16 |
SST |
1 |
UTC |
17 |
NST |
2 |
ECT |
18 |
MIT |
3 |
EET |
19 |
HST |
4 |
ART |
20 |
AST |
5 |
EAT |
21 |
PST |
6 |
MET |
22 |
PNT |
7 |
NET |
23 |
MST |
8 |
PLT |
24 |
CST |
9 |
IST |
25 |
EST |
10 |
BST |
26 |
IET |
11 |
VST |
27 |
PRT |
12 |
CTT |
28 |
CNT |
13 |
JST |
29 |
AGT |
14 |
ACT |
30 |
BET |
15 |
AET |
31 |
CAT |
Time zone setting |
Time zone code |
Time zone setting |
Time zone code |
|---|---|---|---|
0 |
Pacific/Niue |
161 |
Europe/Belgrade |
1 |
Pacific/Apia |
162 |
Europe/Paris |
2 |
MIT |
163 |
ECT |
3 |
Pacific/Pago_Pago |
164 |
Africa/Bujumbura |
4 |
Pacific/Tahiti |
165 |
Africa/Gaborone |
5 |
Pacific/Fakaofo |
166 |
Africa/Lubumbashi |
6 |
Pacific/Honolulu |
167 |
Africa/Maseru |
7 |
HST |
168 |
Africa/Blantyre |
8 |
America/Adak |
169 |
Africa/Maputo |
9 |
Pacific/Rarotonga |
170 |
Africa/Kigali |
10 |
Pacific/Marquesas |
171 |
Africa/Khartoum |
11 |
Pacific/Gambier |
172 |
Africa/Mbabane |
12 |
America/Anchorage |
173 |
Africa/Lusaka |
13 |
AST |
174 |
Africa/Harare |
14 |
Pacific/Pitcairn |
175 |
CAT |
15 |
America/Vancouver |
176 |
Africa/Johannesburg |
16 |
America/Tijuana |
177 |
Europe/Sofia |
17 |
America/Los_Angeles |
178 |
Europe/Minsk |
18 |
PST |
179 |
Asia/Nicosia |
19 |
America/Dawson_Creek |
180 |
Europe/Tallinn |
20 |
America/Phoenix |
181 |
Africa/Cairo |
21 |
PNT |
182 |
ART |
22 |
America/Edmonton |
183 |
Europe/Helsinki |
23 |
America/Mazatlan |
184 |
Europe/Athens |
24 |
America/Denver |
185 |
Asia/Jerusalem |
25 |
MST |
186 |
Asia/Amman |
26 |
America/Belize |
187 |
Asia/Beirut |
27 |
America/Regina |
188 |
Europe/Vilnius |
28 |
Pacific/Galapagos |
189 |
Europe/Riga |
29 |
America/Guatemala |
190 |
Europe/Chisinau |
30 |
America/Tegucigalpa |
191 |
Europe/Bucharest |
31 |
America/El_Salvador |
192 |
Europe/Kaliningrad |
32 |
America/Costa_Rica |
193 |
Asia/Damascus |
33 |
America/Winnipeg |
194 |
Europe/Kiev |
34 |
Pacific/Easter |
195 |
Europe/Istanbul |
35 |
America/Mexico_City |
196 |
EET |
36 |
America/Chicago |
197 |
Asia/Bahrain |
37 |
CST |
198 |
Africa/Djibouti |
38 |
America/Porto_Acre |
199 |
Africa/Asmera |
39 |
America/Bogota |
200 |
Africa/Addis_Ababa |
40 |
America/Guayaquil |
201 |
EAT |
41 |
America/Jamaica |
202 |
Africa/Nairobi |
42 |
America/Cayman |
203 |
Indian/Comoro |
43 |
America/Managua |
204 |
Asia/Kuwait |
44 |
America/Panama |
205 |
Indian/Antananarivo |
45 |
America/Lima |
206 |
Asia/Qatar |
46 |
America/Indianapolis |
207 |
Africa/Mogadishu |
47 |
IET |
208 |
Africa/Dar_es_Salaam |
48 |
America/Nassau |
209 |
Africa/Kampala |
49 |
America/Montreal |
210 |
Asia/Aden |
50 |
America/Havana |
211 |
Indian/Mayotte |
51 |
America/Port-au-Prince |
212 |
Asia/Riyadh |
52 |
America/Grand_Turk |
213 |
Asia/Baghdad |
53 |
America/New_York |
214 |
Europe/Simferopol |
54 |
EST |
215 |
Europe/Moscow |
55 |
America/Antigua |
216 |
Asia/Tehran |
56 |
America/Anguilla |
217 |
MET |
57 |
America/Curacao |
218 |
Asia/Dubai |
58 |
America/Aruba |
219 |
Indian/Mauritius |
59 |
America/Barbados |
220 |
Asia/Muscat |
60 |
America/La_Paz |
221 |
Indian/Reunion |
61 |
America/Manaus |
222 |
Indian/Mahe |
62 |
America/Dominica |
223 |
Asia/Yerevan |
63 |
America/Santo_Domingo |
224 |
NET |
64 |
America/Grenada |
225 |
Asia/Baku |
65 |
America/Guadeloupe |
226 |
Asia/Aqtau |
66 |
America/Guyana |
227 |
Europe/Samara |
67 |
America/St_Kitts |
228 |
Asia/Kabul |
68 |
America/St_Lucia |
229 |
Indian/Kerguelen |
69 |
America/Martinique |
230 |
Asia/Tbilisi |
70 |
America/Montserrat |
231 |
Indian/Chagos |
71 |
America/Puerto_Rico |
232 |
Indian/Maldives |
72 |
PRT |
233 |
Asia/Dushanbe |
73 |
America/Port_of_Spain |
234 |
Asia/Ashkhabad |
74 |
America/St_Vincent |
235 |
Asia/Tashkent |
75 |
America/Tortola |
236 |
Asia/Karachi |
76 |
America/St_Thomas |
237 |
PLT |
77 |
America/Caracas |
238 |
Asia/Bishkek |
78 |
Antarctica/Palmer |
239 |
Asia/Aqtobe |
79 |
Atlantic/Bermuda |
240 |
Asia/Yekaterinburg |
80 |
America/Cuiaba |
241 |
Asia/Calcutta |
81 |
America/Halifax |
242 |
IST |
82 |
Atlantic/Stanley |
243 |
Asia/Katmandu |
83 |
America/Thule |
244 |
Antarctica/Mawson |
84 |
America/Asuncion |
245 |
Asia/Thimbu |
85 |
America/Santiago |
246 |
Asia/Colombo |
86 |
America/St_Johns |
247 |
Asia/Dacca |
87 |
CNT |
248 |
BST |
88 |
America/Fortaleza |
249 |
Asia/Almaty |
89 |
America/Cayenne |
250 |
Asia/Novosibirsk |
90 |
America/Paramaribo |
251 |
Indian/Cocos |
91 |
America/Montevideo |
252 |
Asia/Rangoon |
92 |
America/Buenos_Aires |
253 |
Indian/Christmas |
93 |
AGT |
254 |
Asia/Jakarta |
94 |
America/Godthab |
255 |
Asia/Phnom_Penh |
95 |
America/Miquelon |
256 |
Asia/Vientiane |
96 |
America/Sao_Paulo |
257 |
Asia/Saigon |
97 |
BET |
258 |
VST |
98 |
America/Noronha |
259 |
Asia/Bangkok |
99 |
Atlantic/South_Georgia |
260 |
Asia/Krasnoyarsk |
100 |
Atlantic/Jan_Mayen |
261 |
Antarctica/Casey |
101 |
Atlantic/Cape_Verde |
262 |
Australia/Perth |
102 |
America/Scoresbysund |
263 |
Asia/Brunei |
103 |
Atlantic/Azores |
264 |
Asia/Hong_Kong |
104 |
Africa/Ouagadougou |
265 |
Asia/Ujung_Pandang |
105 |
Africa/Abidjan |
266 |
Asia/Macao |
106 |
Africa/Accra |
267 |
Asia/Kuala_Lumpur |
107 |
Africa/Banjul |
268 |
Asia/Manila |
108 |
Africa/Conakry |
269 |
Asia/Singapore |
109 |
Africa/Bissau |
270 |
Asia/Taipei |
110 |
Atlantic/Reykjavik |
271 |
Asia/Shanghai |
111 |
Africa/Monrovia |
272 |
CTT |
112 |
Africa/Casablanca |
273 |
Asia/Ulan_Bator |
113 |
Africa/Timbuktu |
274 |
Asia/Irkutsk |
114 |
Africa/Nouakchott |
275 |
Asia/Jayapura |
115 |
Atlantic/St_Helena |
276 |
Asia/Pyongyang |
116 |
Africa/Freetown |
277 |
Asia/Seoul |
117 |
Africa/Dakar |
278 |
Pacific/Palau |
118 |
Africa/Sao_Tome |
279 |
Asia/Tokyo |
119 |
Africa/Lome |
280 |
JST |
120 |
GMT |
281 |
Asia/Yakutsk |
121 |
UTC |
282 |
Australia/Darwin |
122 |
Atlantic/Faeroe |
283 |
ACT |
123 |
Atlantic/Canary |
284 |
Australia/Adelaide |
124 |
Europe/Dublin |
285 |
Australia/Broken_Hill |
125 |
Europe/Lisbon |
286 |
Australia/Hobart |
126 |
Europe/London |
287 |
Antarctica/DumontDUrville |
127 |
Africa/Luanda |
288 |
Pacific/Truk |
128 |
Africa/Porto-Novo |
289 |
Pacific/Guam |
129 |
Africa/Bangui |
290 |
Pacific/Saipan |
130 |
Africa/Kinshasa |
291 |
Pacific/Port_Moresby |
131 |
Africa/Douala |
292 |
Australia/Brisbane |
132 |
Africa/Libreville |
293 |
Asia/Vladivostok |
133 |
Africa/Malabo |
294 |
Australia/Sydney |
134 |
Africa/Niamey |
295 |
AET |
135 |
Africa/Lagos |
296 |
Australia/Lord_Howe |
136 |
Africa/Ndjamena |
297 |
Pacific/Ponape |
137 |
Africa/Tunis |
298 |
Pacific/Efate |
138 |
Africa/Algiers |
299 |
Pacific/Guadalcanal |
139 |
Europe/Andorra |
300 |
SST |
140 |
Europe/Tirane |
301 |
Pacific/Noumea |
141 |
Europe/Vienna |
302 |
Asia/Magadan |
142 |
Europe/Brussels |
303 |
Pacific/Norfolk |
143 |
Europe/Zurich |
304 |
Pacific/Kosrae |
144 |
Europe/Prague |
305 |
Pacific/Tarawa |
145 |
Europe/Berlin |
306 |
Pacific/Majuro |
146 |
Europe/Copenhagen |
307 |
Pacific/Nauru |
147 |
Europe/Madrid |
308 |
Pacific/Funafuti |
148 |
Europe/Gibraltar |
309 |
Pacific/Wake |
149 |
Europe/Budapest |
310 |
Pacific/Wallis |
150 |
Europe/Rome |
311 |
Pacific/Fiji |
151 |
Europe/Vaduz |
312 |
Antarctica/McMurdo |
152 |
Europe/Luxembourg |
313 |
Asia/Kamchatka |
153 |
Africa/Tripoli |
314 |
Pacific/Aucklandoo |
154 |
Europe/Monaco |
315 |
NST |
155 |
Europe/Malta |
316 |
Pacific/Chatham |
156 |
Africa/Windhoek |
317 |
Pacific/Enderbury |
157 |
Europe/Amsterdam |
318 |
Pacific/Tongatapu |
158 |
Europe/Oslo |
319 |
Asia/Anadyr |
159 |
Europe/Warsaw |
320 |
Pacific/Kiritimati |
160 |
Europe/Stockholm |
