ASE text field to ASA text field

Hi

I'm having problems populating an ASA text field with data from an ASE text 
field using CIS(component integration services) from ASE to link up to ASA. 
After running the SQL statement it appears to put NULLS in the ASA field. 
All other data types appear to work fine. I know you can use 
readtext/writetext to read/write text fields properly but it requires a 
size parameter. Any thoughts or suggestions would be appreciated.

Here is the SQL I'm trying to run;

insert asa_invt_prod_note
select 
invt_prod_id,note_type,note,fpi_rep_status_flag,created_date,created_by,updated_date,updated_by,lock_count
from research_tst.dbo.invt_prod_note 
where invt_prod_id = 37500003 and note_type = 'B'

*The note field in the above is the text field.

0
Ange
2/27/2002 6:19:55 AM
sybase.sqlanywhere.general 32637 articles. 4 followers. Follow

2 Replies
1056 Views

Similar Articles

[PageSpeed] 32

Version 8 ASA works find when "pulling" text columns from ASE 12, via
a proxy table defined in ASA. CIS facilities are built in to ASA and
they work well.

I'm just guessing, but your SQL looks like the proxy table is defined
in ASE and you are "pushing" the data... this is something I haven't
tried.

What version and build of ASA are you using? E.g., 8.0.0.2065.

What version of ASE are you using?

What does the ASE catalog say about the datatype of
asa_invt_prod_note.note?

Can you try it the other way 'round? (pull from ASA)... just to see if
it works. This will help narrow down the problem.

Breck

On Wed, 27 Feb 2002 01:19:55 -0500, Ange wrote:

>Hi
>
>I'm having problems populating an ASA text field with data from an ASE text 
>field using CIS(component integration services) from ASE to link up to ASA. 
>After running the SQL statement it appears to put NULLS in the ASA field. 
>All other data types appear to work fine. I know you can use 
>readtext/writetext to read/write text fields properly but it requires a 
>size parameter. Any thoughts or suggestions would be appreciated.
>
>Here is the SQL I'm trying to run;
>
>insert asa_invt_prod_note
>select 
>invt_prod_id,note_type,note,fpi_rep_status_flag,created_date,created_by,updated_date,updated_by,lock_count
>from research_tst.dbo.invt_prod_note 
>where invt_prod_id = 37500003 and note_type = 'B'
>
>*The note field in the above is the text field.

bcarter@risingroad.com
Mobile and Distributed Enterprise Database Applications
-----
Visit http://www.risingroad.com for Tips and Techniques
[TeamSybase]
0
Breck
2/27/2002 1:20:52 PM
You might also want to post this the ASE newsgroups
since (as Breck does point out) the ASE CIS layer is
the active agent involved here.

With ASE CIS there are 11200 series trace flags that
can help you diagnose this further.

Reference:

Component Integration Services User's Guide for ASE and OmniConnect
Appendix B/Chapter 5 Troubleshooting

and this one too
Component Integration Services User's Guide for ASE and OmniConnect
      2    Chapter 3 SQL reference
      2    dbcc commands
      2   Trace flags





"Breck Carter" <NOSPAM__bcarter@risingroad.com> wrote in message
news:dvmp7uk4b7isrt1lntgp90u3gei58dj9sk@4ax.com...
> Version 8 ASA works find when "pulling" text columns from ASE 12, via
> a proxy table defined in ASA. CIS facilities are built in to ASA and
> they work well.
>
> I'm just guessing, but your SQL looks like the proxy table is defined
> in ASE and you are "pushing" the data... this is something I haven't
> tried.
>
> What version and build of ASA are you using? E.g., 8.0.0.2065.
>
> What version of ASE are you using?
>
> What does the ASE catalog say about the datatype of
> asa_invt_prod_note.note?
>
> Can you try it the other way 'round? (pull from ASA)... just to see if
> it works. This will help narrow down the problem.
>
> Breck
>
> On Wed, 27 Feb 2002 01:19:55 -0500, Ange wrote:
>
> >Hi
> >
> >I'm having problems populating an ASA text field with data from an ASE
text
> >field using CIS(component integration services) from ASE to link up to
ASA.
> >After running the SQL statement it appears to put NULLS in the ASA field.
> >All other data types appear to work fine. I know you can use
> >readtext/writetext to read/write text fields properly but it requires a
> >size parameter. Any thoughts or suggestions would be appreciated.
> >
> >Here is the SQL I'm trying to run;
> >
> >insert asa_invt_prod_note
> >select
>
>invt_prod_id,note_type,note,fpi_rep_status_flag,created_date,created_by,upd
ated_date,updated_by,lock_count
> >from research_tst.dbo.invt_prod_note
> >where invt_prod_id = 37500003 and note_type = 'B'
> >
> >*The note field in the above is the text field.
>
> bcarter@risingroad.com
> Mobile and Distributed Enterprise Database Applications
> -----
> Visit http://www.risingroad.com for Tips and Techniques
> [TeamSybase]


begin 666 i_colpse.gif
M1TE&.#EA"0`)`(#_`,# P "$_R'Y! $`````+ `````)``D`0 (1C'^@$+O8
-%#0NR4GQ0XY150``.P``
`
end

0
Nick
2/27/2002 7:57:21 PM
Reply:

Similar Artilces:

RE: ASA text field to ASA text field
Hi Sorry the versions I was using for the problem below were. Using ASE version 11.9.2.5 Using ASA version 6.0.3.3113 I'm trying to push data from ASE text to ASA text, I also had problems pulling an ASE text field from ASA using proxy tables. I'm having problems populating an ASA text field with data from an ASE text field using CIS(component integration services) from ASE to link up to ASA. After running the SQL statement it appears to put NULLS in the ASA field. All other data types appear to work fine. I know you can use readtext/writetext to read/write...

Format text field and field text box in datagrid
I have a column that allows the user to edit the datagrid.  When the Edit link is clicked, only one column is editable...this works.  The problems are that:1) the text box is only 75% of the width of the column2) when i type text into the text field, the size is a lot larger than the text in other non-editable columns3) the height of the text-box is too high.In summar, how can i format the editable field?I have tried doing so, in the Propery Builder>Format and changing the settings in the 'Edit Mode Items', that does not help.  I'm trying to use the XX-Small text size....

Text not appearing when typing the text into text field
Name: Maadhavan Email: madhavan_t_patyahoodotcom Product: Firefox Summary: Text not appearing when typing the text into text field Comments: Text not appearing when typing the text into text field or any other field Browser Details: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.9) Gecko/2009040821 Firefox/3.0.9 From URL: http://hendrix.mozilla.org/ Note to readers: Hendrix gives no expectation of a response to this feedback but if you wish to provide one you must BCC (not CC) the sender for them to see it. ...

Synchronization between Oracle clob field and ASA text field
Does anyone know whether the Oracle clob field can be synchronized with the ASA text field? Thanks, liyp Liy, The Oracle data mappings can be found here: http://dcx.sybase.com/index.html#1101en/mlserver_en11/oracle-datatypes-ml-ref.html There are a variety of options you have for defining the data type in SQL Anywhere or UltraLite. Yes, the SA TEXT data types does map to Oracle CLOB, but please read the Notes. -- Joshua Savill Sybase Inc. - Product Manager liy wrote: > Does anyone know whether the Oracle clob field can be synchronized with the > ASA ...

text field with prepopulated text
I have a web form, there is an address text field, for my purpose, I only need it into this one field for street address city, state, zip. I would like to have something like street address city, state, zip in the text box when page load, but when the user click the text field, it goes blank, so the user can enter their own address. How can I do this? Thanks Hi,this can be done by prefilling it in the page_load for example and then use javascript onfocus event to clear out the value of the textbox. Another way to go is to use the Textboxwatermark extender from the ASP.NET AJAX Control ...

superreview requested: [Bug 390228] Redragging over empty text field doesn' t show drag caret, except for the last text field
Blake Kaplan <mrbkap@gmail.com> has asked Robert O'Callahan <roc@ocallahan.org> for superreview: Bug 390228: Redragging over empty text field doesn't show drag caret, except for the last text field https://bugzilla.mozilla.org/show_bug.cgi?id=390228 Attachment 275181: Proposed fix https://bugzilla.mozilla.org/attachment.cgi?id=275181&action=edit ------- Additional Comments from Blake Kaplan <mrbkap@gmail.com> This fix also fixes the caret flicker problem by not erasing the caret automatically each time editor asks it to. The actual problem here was th...

superreview granted: [Bug 390228] Redragging over empty text field doesn' t show drag caret, except for the last text field
Robert O'Callahan <roc@ocallahan.org> has granted Blake Kaplan <mrbkap@gmail.com>'s request for superreview: Bug 390228: Redragging over empty text field doesn't show drag caret, except for the last text field https://bugzilla.mozilla.org/show_bug.cgi?id=390228 Attachment 275181: Proposed fix https://bugzilla.mozilla.org/attachment.cgi?id=275181&action=edit ...

Problem in assinging text to a text field
I cannot assign a text like 'Yes','No' or a name ending with ~ or " to a text field in datawindow .The error is Error accessing external object property text.I am using Powerbuilder 7.0.2 Build 8011. Please post the code you are using -- Simon Caldwell Get Real Systems Ltd Holtby Manor, Stamford Bridge Road, York, YO19 5LL Tel 01904 481999 Fax 01904 481666 Visit us at www.getrealsystems.com Specialists in e-Procurement and supply chain technology "Saif" <nazkal9008@hotmail.com> wrote in message news:DF55C9C8B4C755A2004C83BA852569DB.0...

Determining if a text field has hidden text
Revisiting an old question........Is there a way to determine if a notes field has extended text hidden from view on the form? I was thinking the most logical way was to use "describe" to determine if that particular notes field vscroll has been invoked......assuming it was set to true in the first place The reason I want to know this if the user wants to print off the form I want to be able to provide all the notes in print as a supplemental page.........As a work around I've best guessed and said if the text len > x then print an overflow sheet but that'...

BCP in one field is a TEXT field
Hi all! I have a text file with approx 1.6 million rows in it and I have to insert them in my ASE table. I was going to use BCP in but I keep getting truncation message, although it inserted the data. My guess is the text field bec in the format file(.fmt file) SYBCHAR can only read till 240 chars. Is there a way to go around this? maybe, expand the number of chars for the text field or is there another SYB??? I can use? Any help, suggestion is greatly appreciated. TIA. Check out the ASE/Utilities manual, chapter on using bcp ... The 12.5.1 version of the manual has a list of po...

Read text file into text field
Hi,How may I read the contents of a text file into a text field?The text file is located at server-side and the text field is in a web page (i.e., client side).The reason is, suppose the text file contains a list of 10 entities, the user may be able to edit the list in the text field and not type everything out himself. (e.g. for searching).Thanks for reading! You can read your Text File into a String or StringBuilder object server side, and use this String for theText Property of your TextBox:    Dim file As New System.IO.StreamReader("c:\test.txt")  &nb...

DataGrid field and a URL text field
Hello,  I created a datagrid on a form and with a query I fill the datagrid with information from a table in Access.  All the data from the table is displayed in the datagrid fields, except for two. I'll call them FieldA and FieldB. Usually these fields contain URL information. If there happens to be other information other than a url in these fields then this data does display however a url does not. An example of the contents of a field that won't display could be: <http://www.msnbc.com> What I need to do is display the url an...

Make a text field Readonly field
I'm trying the property of few textboxes to readonly. I get their values with the following piece of code.private BusinessLogic.Objects.User EditUser { get {  return this.usrUser.CurrentUser; } set {  this.usrUser.CurrentUser = value;   } } I need to set the values usrUser.CurrentUser.Name , usrUser.CurrentUser.Phone, usrUser.CurrentUser.Email as readonly. I've done this before by typing this.usrUser.CurrentUser.Name.Readonly=true. But I get an error that there is no property definition. When I debugged it, the value for this.usrUser.CurrentUser. I ...

Text jumps to next text field
Name: John Haran Email: jpharanattoastdotnet Product: Firefox Summary: Text jumps to next text field Comments: Would someone PLEASE tell me why the text I'm typing in Firefox tends to jump, on it's own, to the next text box? For instance, I can be typing the subject matter in an email and the text just jumps down and starts filling in the main text field. Or, I can be typing text into a text box in ebay and it just starts filling in the next text field down. This only happens with Firefox, not safari, not IE, just firefox. I don't want to resort to writing to yo...

Web resources about - ASE text field to ASA text field - sybase.sqlanywhere.general

Field - Wikipedia, the free encyclopedia
Field (computer science) , a smaller piece of data from a larger collection (e.g., database fields) Text is available under the Creative Commons ...

Plans lodged for Melrose High School sports fields upgrades
Development plans have been lodged for the $6.7 million upgrade to the Melrose High School oval and sports precinct.

None of the Republican candidates know how to do field — especially Trump
Field campaigns aren’t complicated, but they’re really difficult to do well. That’s because the single most effective way a campaign can win ...

Ford will ultimately get its due from Wall Street, Fields says
... and strategies for the coming year. Coverage of the annual gathering of industry leaders in Detroit. DETROIT Ford Motor Co. CEO Mark Fields ...

Field Music share "Disappointed" from new new LP
by Bill Pearis Field Music's forthcoming album Commontime will be out soon February 5 via Memphis Industries. After getting Peter Brewis' "The ...

Cubs Looking At Closing Streets Around Wrigley Field On Game Days
... are going to have deal with the reality of the world today. (CBS) — There are some big changes in store when Cubs fans return to Wrigley Field ...

The Nightly Show Has A Field Day With Oregon Militia Group Receiving Sex Toys
As we already discussed here , some of those Islamophobic "patriots" who are holed up at the Malheur National Wildlife Refuge in Oregon are none ...

Big Brother is having a field day in Fresno with scary surveillance technology
You can file this one under: “What in the fuckety fuck?” Surveillance in the U.S. may be entering a new high in terms of technological advances, ...

Danny Fields Rock Docu ‘Danny Says’ Acquired By Magnolia
... Says , a new documentary directed by Brendon Toller chronicling the iconic life and times of the influential punk and rock figure Danny Fields ...

Report: Top Track & Field Officials Discussed Covering Up Doping Prior To London Olympics
... the World Anti-Doping Agency released a bombshell report detailing all manner of doping, bribing, and cover-ups by Russian track and field athletes, ...

Resources last updated: 1/17/2016 2:35:27 PM