CREATE PROCEDURE sp_setseed(n INTEGER) DEFINE GLOBAL seed DECIMAL(10) DEFAULT 1; LET seed = n; END PROCEDURE; CREATE PROCEDURE sp_random() RETURNING INTEGER; DEFINE GLOBAL seed DECIMAL(10) DEFAULT 1; DEFINE d DECIMAL(20,0); LET d = (seed * 1103515245) + 12345; -- MOD function does not handle 20-digit values... Dammit!! LET seed = …
Devamını Oku »informix var olan bir tabloya serial primary key ekleme
alter table tblname add id integer; create sequence tblname_seq; update tblname set id = tblname_seq.nextval; drop sequence tblname_seq; alter table tblname modify (id serial not null); ALTER TABLE tblname ADD CONSTRAINT PRIMARY KEY (id);
Devamını Oku »Informix table primary key sql
SELECT a.tabname, b.constrname, d.colname FROM systables a, sysconstraints b, sysindexes c, syscolumns d WHERE a.tabname = :table_name AND b.tabid = a.tabid AND c.idxname = b.idxname AND d.tabid = a.tabid AND ( d.colno = c.part1 or d.colno = c.part2 or d.colno = c.part3 or d.colno = c.part4 or d.colno = c.part5 …
Devamını Oku »informix tüm tablolarda eklenmemiş bir alanı bulma
SELECT tabname FROM database_name:systables t1 WHERE t1.tabid >= 100 AND NOT EXISTS (SELECT * FROM database_name:syscolumns c WHERE c.tabid = t1.tabid and c.colname = 'adddate' ) order by 1;
Devamını Oku »Informix unload file to postgresql import
TBL_TEST.unl dosyamızın sonunda ki pipe “|” yok etmek için python da küçük bir script ile temizleme yapıyoruz. fpath = 'deneme.unl' def read_big_file_pipe(): with open(fpath) as infile: with open("new_deneme.unl", "a", encoding='utf-8') as file_object: for line in infile: new_line = line[:-2]+'\n' file_object.write(new_line) postgresql sunucusunda ki tmp dizinine kopyalıyoruz. tablomuzu ilgili veritabanında …
Devamını Oku »informix server restart
onmode -uky tekrar açmak için oninit
Devamını Oku »python informix char to nchar varchar to nvarchar replace
import re import sys import getopt import os exclude_rows = ['informix.syserrors', 'informix.systracemsgs', 'informix.systraceclasses', 'grant dba to', 'grant resource to', 'create role ', 'sysbldsqltext', 'create explicit cast', 'create implicit cast'] GRANT_EXECUTE_ON_FUNCTION = 'grant execute on function' GRANT_EXECUTE_ON_PROCEDURE = 'grant execute on procedure' def file_to_list(fname) -> list: with open(fname, encoding='ansi') as f: …
Devamını Oku »informix table sizeof disk
select tn.partnum , tn.dbsname , (pt.nptotal * pt.pagesize) /1024 as total_kb , (pt.npused * pt.pagesize) /1024 as used_kb , (pt.npused * pt.pagesize) / 1024 /1024/1024 as used_gb , (pt.npdata * pt.pagesize) /1024 as data_kb , tn.owner , tn.tabname , pt.lockid, pt.flags, pt.flags2 , pt.rowsize, pt.ncols, pt.pagesize , dbinfo('utc_to_datetime',pt.created) as created …
Devamını Oku »Informix lock user sesion list
SELECT s.username tutan_kullanici, s.sid tutan_session, t.username bekleyen_kullanici, t.sid bekleyen_session, l.type locktype, l.dbsname veritabani, l.tabname tablo, l.rowidlk tutulan_rowid FROM sysmaster:syslocks l INNER JOIN sysmaster:syssessions s ON s.sid = l.owner LEFT JOIN sysmaster:syssessions t ON l.waiter = t.sid WHERE l.dbsname <> 'sysmaster' and l.tabname <> 'sysdatabases' ORDER BY veritabani, l.tabname;
Devamını Oku »informix get last insert id
Evet çok saçma CREATE TEMP TABLE zamazingo (ID INT); INSERT INTO mytable (ciger,adana,lahmacun,pide,doner) VALUES ('miger','madana','mahmacun','mide','moner'); INSERT INTO zamazingo (ID) VALUES (dbinfo('sqlca.sqlerrd1')); select id from zamazingo
Devamını Oku »