Whuah… stress ngeliat Diky ngetik-ngetik script ini.. thh pikirku :))

CREATE OR REPLACE VIEW VW_AKTOPR
(KD_PINJ, KD_PELUNASAN, TGL_ANGSURAN, POKOKOPR, BUNGAOPR,
POKOK_AKT, BUNGA_AKT)
AS
select kd_pinj,kd_pelunasan, tgl_angsuran, pokokopr, bungaopr, pokok_akt, bunga_akt from
(
select subl2,no_pointer, sum(nvl(pokok_akt,0))pokok_akt, sum(nvl(bunga_akt,0)) bunga_akt from
(
select b.subl2,no_pointer,null pokok_akt, sum(nvl(kredit,0))- sum(nvl(debet,0)) bunga_akt from gl_ktvouc a,gl_trvouc b
where a.kd_ktr=b.kd_ktr and a.kd_bln=b.kd_bln and a.kd_bank = b.kd_bank and a.tgl_trans=b.tgl_trans
and a.kd_buku=b.kd_buku and a.kd_trans =b.kd_trans
and b.akun like ‘72%’
group by b.subl2,no_pointer
Mari melihat selengkapnya…… Silahkeun »

Popularity: 8% [?]

I was trying install Oracle 8i onto my computer under Windows OS, but it was strange. After “setup” file is clicked, busy icon is appear but nothing happened then.

I tried to install on notebook, everything was ok. The installation was run properly.

Got confused, I asked google for this problem, and here is the answer:

———–
If you are using P4…Its a known bug…Here is a easiest workaround assuming your processor is a Pentium 4 …

1. Create a temporary directory on your server.
2. Copy the contents of the Oracle RDBMS CD to the temporary directory created in step 1.

3. Search the directory structure created in step 1 for the existence of the filename symcjit.dll….mostly you will find 2 files

4. Rename each copy of the symcjit.dll to symcjit.old.

5. Run the setup.exe from the installwin32 directory and install Oracle 8.1.x.

———–

thats it

Popularity: 6% [?]

I\’ve looked for DKU-5 Driver for Linux, but it\’s still not found. It seems unavailable coz even NOKIA is still not provide it.

Anyone can help?

Popularity: 5% [?]

Dulu Yahoo!Mail sempat memberikan layanan POP3 untuk free emailnya. Tapi itu dulu. Kalau kita sekarang ingin menikmati fasilitas POP3 tersebut gimana caranya? Selain meng-upgrade account (tidak free lagi tentunya ), YPOPs! dapat mengimplementasikannya.

Aq udah coba pake di Linux yang versi 0.8.6.2, dan berjalan baik (untuk versi Windows udah lebih terbaru).

Klo di account mail kita ada lebih dari satu folder, kita juga bisa me-retrieve semua folder tersebut dengan cara di file ypops.ini, pada bagian “Folders=” masukkan nama folder-folder yang ada di account Yahoo dengan separator “|”.

Misalkan pada account Yahoo kita punya folder friendster, training, dan project, maka dibuat seperti ini:
“Folders=friendster|training|project“ tanpa spasi dan tanpa tanda petik (”).

Pada file ypops.ini tersebut yang penting juga untuk diketahui ada nilai variable SmtpPort dan Pop3Port, karena ini sangat diperlukan untuk men-setting mail client nantinya.

Untuk setting email client-nya, petunjuknya ada di sini.

Selamat mencoba dan ber POP3 ria

Popularity: 6% [?]

pre { padding: 1em; border: 1px dashed #2f6fab; color: black; background-color: #f9f9e9; line-height: 1.5em; font-size:9pt}
Whatever the reason is, but sometimes we decided to change column type of table. It’s quite easy to implement the patch it MySQL, but not in PostgreSQL (I’m currently using pgsql 8.14).

There are two ways (I just know those two) to solve that problem:

1st solution:BEGIN;

ALTER TABLE table_name ADD COLUMN new_col new_data_type;

UPDATE table_name SET new_col = CAST(old_col AS new_data_type);

ALTER TABLE table_name DROP COLUMN old_col;

COMMIT;

However, It is used when we want to change type of the latest column (its position in the table), except we can determine to add column in the certain position.

Since it cannot be used in all situations, I have found another way to solve that problem:

2nd solution:1) Copy old table to temporary table

CREATE TABLE temp AS SELECT * FROM old_table;2) Drop old table

DROP TABLE old_table;

3) Create new table (as required structure)

CREATE TABLE new_table ( col1 type(xx), col2 type(xx) );

4) insert data dari table temporary ke table baru

INSERT INTO new_table SELECT * FROM temp ;

Yeah.. that’s it! I think it will be useful.

Popularity: 4% [?]

Untuk beberapa kasus, kita menginginkan koneksi ssh tidak memerlukan password. How to make it? Here is a simple way:

—- Jalanin command berikut di Client:
$ mkdir -p $HOME/.ssh

$ chmod 0700 $HOME/.ssh

$ ssh-keygen -t dsa -f $HOME/.ssh/id_dsa -P ‘’

—- Command di atas akan men-generate dua files
Untuk beberapa kasus, kita menginginkan koneksi ssh tidak memerlukan password. How to make it? Here is a simple way:

—- Jalanin command berikut di Client:
$ mkdir -p $HOME/.ssh

$ chmod 0700 $HOME/.ssh

$ ssh-keygen -t dsa -f $HOME/.ssh/id_dsa -P ‘’

—- Command di atas akan men-generate dua files
Untuk beberapa kasus, kita menginginkan koneksi ssh tidak memerlukan password. How to make it? Here is a simple way:

—- Jalanin command berikut di Client:
$ mkdir -p $HOME/.ssh

$ chmod 0700 $HOME/.ssh

$ ssh-keygen -t dsa -f $HOME/.ssh/id_dsa -P ‘’

—- Command di atas akan men-generate dua files
- $HOME/.ssh/id_dsa (private key) dan

- $HOME/.ssh/id_dsa.pub (public key)

—- Copy $HOME/.ssh/id_dsa.pub ke Server

—- Jalanin command berikut di Server
$ cat id_dsa.pub >> $HOME/.ssh/authorized_keys2
$ chmod 0600 $HOME/.ssh/authorized_keys2

—- Tergantung versi SSH yang digunakan, ada versi yang menggunakan file authorized_keys (bukan authorized_keys2). Sebaiknya jalanin command berikut:
$ cd $HOME/.ssh && ln -s authorized_keys2 authorized_keys

—- Coba konek dari Client:
$ ssh -i $HOME/.ssh/id_dsa

Note: - ssh-keygen -t dsa berarti menggunakan protokol DSA. Untuk menggunakan protokol RSAm ganti setiap dsa menjadi rsa.

Manual:
- ssh(1)

- ssh-keygen(1)

- ssh_config(5)

Popularity: 5% [?]

Waktu nginstall source tarbal on Linux, pernah ngeliat pesan gini ato yang sejenisnya?

mysql.o(.text+0×1bda): In function `com_source(String*, char*)’:
: undefined reference to `errno’
collect2: ld returned 1 exit status
make[2]: *** [mysql] Error 1
make[2]: Leaving directory `/opt/mysql-3.23.49/client’
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/opt/mysql-3.23.49′
make: *** [all-recursive-am] Error 2

Aq dapat pesan gini waktu nginstall mysql-3-23.49. Awalnya aq kirain itu karena versi MySQL nya yang udah ga relevan. Tapi emang dimintanya nginstall itu.. mo gimana lagi..

Ternyata error yg begitu bukan karena ada ‘apa-apa’ di sourcenya, tapi karena sang compilernya tidak menyertakan header file error.h sewaktu meng-compile source nya.

So, solusinya cari file yang membutuhkan error.h, yakni yang mengandung code:
extern int errno;
dengan ‘grep’ ato ‘mc’ ato script ato cara lain (waktu itu aq pake mc.. abis lebih gampang sih) :);
Lalu include-kan file header error.h di file-(file) tersebut dengan menambahkan baris:
#include
Salam

Popularity: 5% [?]