Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Tools Development

User login

Frontpage Sponsor

Main

Google search


Poll
How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
17%
200 - 500 GB
30%
500 - 800 GB
3%
800 - 1200 GB
7%
1200 - 1500 GB
10%
1500 - 2000 GB
13%
> 2000 GB
20%
Total votes: 30

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 19th April 2015, 07:09
sang1285's Avatar
sang1285 sang1285 is offline
Member
 
Join Date: Oct 2013
Location: Dubai
Posts: 34
sang1285 is on a distinguished road
Baan: BAAN 5 - DB: Oracle - OS: Unix
String of 5000 chars
Baan: Other/Unknown
C/S: None/Unknown

Hello,

We are storing some data in a string variable and writing it to a file on unix using seq.puts function.

Currently even if we declare the string variable of length more than 2048, it truncates the remaining data.

We would like to know if it is possible to define a string of more than 2048 characters?

Thanks & Regards,
Sangeeta
__________________
Thanks & Regards,
Sangeeta
Reply With Quote
  #2  
Old 19th April 2015, 10:48
bhushanchanda's Avatar
bhushanchanda bhushanchanda is offline
Guru
 
Join Date: Sep 2012
Location: India
Posts: 2,356
bhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura about
Baan: LN FP 1-9, 10.4, a little bit of Baan IV - DB: SQL Server 2008, Oracle - OS: Windows Server 2008 R2, Unix
Hi,

I do not think its possible. But, I guess, what you can do is, do a seq.seek() and then do a seq.write(). This way you can divide your 5000 length string into parts and write to the file.
__________________
Regards,

Bhushan

Unless you try to do something beyond what you have already mastered, you will never grow!
Reply With Quote
Sponsored Links
  #3  
Old 19th April 2015, 12:14
bdittmar's Avatar
bdittmar bdittmar is offline
Guru
 
Join Date: Apr 2002
Location: Germany, 50.584097,8.544078
Posts: 1,726
bdittmar will become famous soon enough
Baan: 2.2/3.1/4c4/LN6.1 FP6/FP9/HiDox - DB: tbase, ms-sql7, oracle10gV1, 11g - OS: HP-UX, W2K3, SLES
Known limits !

Hello,

Known limits
Reports

sorting doubles correct to 6 decimal places
maximum 255 fields on a report (including array elements)
Bshell

maximum string buffer size is 4K – be careful when concatenating strings with '&' sign
maximum function stack depth is 500
Bic

maximum 255 arguments per function
maximum 32K variables per compilation
maximum BRANCH of 32K (BRANCH refers to the amount of generated code per function, including macros etc.)
SQL

The nesting level of subqueries is limited to 10. The nesting level is defined as follows. The nesting level of the main query is 1. The nesting level of a sub query immediately contained in the main query is 2. The nesting level of a sub query immediately contained in another sub query is the nesting level of that sub query plus 1.
The number of index hints that can be given on a table is limited to 4.
The SQL processor has no limit on the length of string values. However, the databases may impose restrictions on the length of string values. It is advised to keep the length of string values (including string literals and string values resulting from concatenation) below 4K.
Tables

maximum record length is 3072 bytes (for multi-byte columns take a factor 2 into account. For example, a multi-byte string of 256 characters will be 512 bytes long in a multi-byte environment.)
maximum number of fields is 1024
maximum field length is 3072 bytes
maximum number of indices per table is 20
Indexes

maximum index length is 500 bytes
maximum number of fields is 24 (no combined fields)

Regards
__________________
//Bernd
Reply With Quote
  #4  
Old 18th July 2018, 17:07
mroset mroset is offline
Junior Member
 
Join Date: Jun 2002
Location: NL
Posts: 10
mroset is on a distinguished road
Baan: Baan IVc, BaanERP, ERPLN 6.1, Basware IP and Alusta, Palette Arena (P2P), AX 3-4-2009-2012-AX7-AX365 - DB: Oracle,Informix,SQL7/2k/2k3/2k8/2k12 - OS: UNIX, NT, 2000, 2003,2008,2012, 2016
I've analyzed this and use long strings in our generic realtime (COM-based and Webservice-based) and batch-oriented (e.g, ASCII/XML) communication framework that's used - among others - in P2P (Purchase-to-Pay applications like Basware IP/Alusta / Palette Arena etc.), and have found the following:

The typical 6.x Baan IV Porting Set (6.1c.07.12 / 6.1c.18) supports string lengths of 132.304/132.296 bytes. If you append strings beyond that, BW crashes (very hard / very nasty) and the memory is core dumped.

Testing this in an LN environment (tested with porting set 8.7b.01 / 2012) , there does not seem to be such a limit. Have only tested it briefly, but with this Porting Set, the string lengths may be even substantially larger or even limited to the limits of the LONG or DOUBLE variables itself.

The programming solution is to use file-based operations to write/read longer strings.
Another (better and quicker) alternative (since it will be done in memory and no I/O takes place) may be to use multidimensional string arrays.
I currently state ' may be' because this is currently being implemented and results are not yet fully known.
Please note that in most situations, strings that can have up to 132.304 characters will suffice. However, when transferring XML-documents (like I do in the framework), this may well be too limited.
Reply With Quote
  #5  
Old 19th July 2018, 15:45
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,137
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
Interesting. Not sure which porting set we are on but with my exports for transitioning to Oracle EBS I am using string lengths of 20k for text extracts. These get loaded into oracle with as long text.
__________________
Mark

GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
DEV: Export any Baan table to (proper) Excel Francesco Code & Utilities 27 2nd September 2011 15:00
Writing Export Conditions ian_j_albert Tools Development 4 22nd July 2010 08:30
Help regarding tools session rahul.kolhe22 Tools Development 4 22nd January 2010 14:31
problems with stpapi.zoom.option Finnigan AFS/DDC/OLE: Function servers 5 3rd November 2009 15:04
File Browser Bogdan Tools Development 52 7th January 2004 09:17


All times are GMT +2. The time now is 08:24.


©2001-2018 - Baanboard.com - Baanforums.com