Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Translate log file

3 posts in General Discussion Last posting was on 2003-09-25 19:47:22.0Z
SMarcoux Posted on 2003-09-25 18:08:36.0Z
From: "SMarcoux" <smarcoux@cbgi.qc.ca>
Newsgroups: ianywhere.public.general
Subject: Translate log file
Lines: 10
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4807.1700
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
X-Original-NNTP-Posting-Host: 207.183.55.74
Message-ID: <3f732fc0$1@forums-2-dub>
X-Original-Trace: 25 Sep 2003 11:11:12 -0700, 207.183.55.74
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 25 Sep 2003 11:04:18 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 25 Sep 2003 11:08:36 -0700
X-Trace: forums-1-dub 1064513316 10.22.108.75 (25 Sep 2003 11:08:36 -0700)
X-Original-Trace: 25 Sep 2003 11:08:36 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1798
Article PK: 4095

Hi!
I've translated my log file.
I want the functions and procedures called by triggers to appear in the log
file (because I do some updates in them).
How can I do this?

Thanks!
smarcoux@cbgi.qc.ca


Don Posted on 2003-09-25 19:28:28.0Z
Sender: c2a.3f734172.1804289383@sybase.com
From: Don
Newsgroups: ianywhere.public.general
Subject: Re: Translate log file
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <3f734276.c34.846930886@sybase.com>
References: <3f732fc0$1@forums-2-dub>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 25 Sep 2003 12:31:02 -0700, 10.22.241.42
Lines: 15
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 25 Sep 2003 12:24:08 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 25 Sep 2003 12:28:28 -0700
X-Trace: forums-1-dub 1064518108 10.22.108.75 (25 Sep 2003 12:28:28 -0700)
X-Original-Trace: 25 Sep 2003 12:28:28 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1799
Article PK: 4080

If you use SQL central- utility - translate log, there is a
option for including trigger actions


,

> Hi!
> I've translated my log file.
> I want the functions and procedures called by triggers to
> appear in the log file (because I do some updates in
> them). How can I do this?
>
> Thanks!
> smarcoux@cbgi.qc.ca
>
>


Reg Domaratzki Posted on 2003-09-25 19:47:22.0Z
From: "Reg Domaratzki" <Spam_bad_rdomarat@ianywhere.com>
Newsgroups: ianywhere.public.general
References: <3f732fc0$1@forums-2-dub>
Subject: Re: Translate log file
Lines: 30
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
X-Original-NNTP-Posting-Host: rdomarat-pc.sybase.com
Message-ID: <3f7346e7@forums-2-dub>
X-Original-Trace: 25 Sep 2003 12:49:59 -0700, rdomarat-pc.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 25 Sep 2003 12:43:04 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 25 Sep 2003 12:47:22 -0700
X-Trace: forums-1-dub 1064519242 10.22.108.75 (25 Sep 2003 12:47:22 -0700)
X-Original-Trace: 25 Sep 2003 12:47:22 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1800
Article PK: 4084

Run dbtran with the -t switch to include trigger actions in your translated
SQL file. Note that the actual stored procedure calls will not be logged,
but the actions taken in the stored procedures will be logged.


--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup

iAnywhere Developer Community : http://www.ianywhere.com/developer
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL

"SMarcoux" <smarcoux@cbgi.qc.ca> wrote in message
news:3f732fc0$1@forums-2-dub...
> Hi!
> I've translated my log file.
> I want the functions and procedures called by triggers to appear in the
log
> file (because I do some updates in them).
> How can I do this?
>
> Thanks!
> smarcoux@cbgi.qc.ca
>
>