Archive

Posts Tagged ‘Rep’

What’s in YOUR Architecture?

December 4th, 2011 No comments

What’s in your architecture?

Probably not enough if you’re using just data modeling to integrate all the components of your enterprise, especially your information. To lay the
foundation of this paper, let’s start from the same level of understanding: the need for a common approach to managing all the aspects of information to
enable rapid business performance in the 21st century economy.

Competition in the marketplace is always fierce. To stay abreast, organizations must constantly analyze their customer needs and expectations, enhance
or innovate their business processes, and deliver products and services that create exceptional customer value. Organizations also need to be customercentric to forge long-term relationships with clients and consumers. Only organizations that are agile enough to respond to volatile market conditions
with innovation, expedited time-to-market processes, and reduced costs can differentiate themselves from the competition. Such agility occurs when a
company’s IT operations are closely aligned with its business operations. IT needs to understand business to implement technologies and applications that
support the current and future business goals.

Read Full Article @ http://www.sybase.com/files/White_Papers/Sybase_Whats_in_Your_Architecture_WP.pdf

bcp copy in failed

August 17th, 2011 No comments

Hi Folks,

Few days back , we  have faced the issue regarding bcp in,  message was bcp copy in failed. Although Rows were inserting successfully.  The user which We were using that was dbo of database and had all
permissions.

We tried with other login id and it was working fine, that was dbo alias.

We tried to remove user, added as  dbo alias, given explicit permission,but it didn’t work out.

It was totally weried as there was no problem at all , or you can say the issue which we were not able to
investigate as error is not much explanatory.

Also I would like to mention , we have refreshed this database from 12.5.4 to 15.0.3 env.

Finally we dropped the user, dropped login account and added again , means we craeted new login account
with same name  and after that added in db as a dbo alias. It worked fine now.
I am still not sure why this caused the issue.

Categories: ASE Tags: , , , ,

If failures is my Destiny, I would like to top in failures!!

August 7th, 2011 No comments

–If 100 plans fail, will make 200 next day!

— If failures is my Destiny, I would like to top in failures!!

Categories: ASE Tags: , , , ,

Sybase: PowerBuilder and PowerDesigner

July 27th, 2011 No comments
  • Sybase PowerBuilder is a RAD tool that lets you develop rich GUI applications,

based on the DataWindow concept.I’ve been told that part of the

SAP POS module is actually developed  with PowerBuilder.

  • Sybase PowerDesigner is a modeling tool that lets you handle anything from a 

data model to a full enterprise architecture, and is widely seen as

one of the best such tools around.

Source : http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/25286
Both PowerBuilder and PowerDesigner are not tied to any specific database and will work with most common database brands.

 Read more...
Categories: ASE Tags: , , , ,

17700 + Hits in sybaseblog.com!

July 26th, 2011 No comments

Hi Guys,

Today your blog crossed the  17700+ hits!!

I would like to congratulate and thanks for your continued support !!!

Thanks once again!

Cheers!!

AnVa

Categories: ASE Tags: , , , ,

Happy Holi to All of you!

March 19th, 2011 No comments

Happy Holi to All of you!

Categories: ASE Tags: , , , ,

Load database: A Recurring Issue!

February 24th, 2011 5 comments

Hi Guys,

As we already aware for loading a database , there cann’t be any user online in the DB.

In our env, we are killing these spids before actual database load in script.

Sometime it works, sometime fails as clinet ids logged in so frequently in server so during the actual load statement database again comes in use status.

This is very frequent issue which I have seen in many enviorment where clined ids logged in very rapidally.

For that we using the some alternative as locking the ids manually and once the load starts we unlock.( We cannt wait untill load finish for unlock of ids) . This task required the manual intervention.

I would like to raise a question, why sybase cann’t provide the load database with kill option, beacuse any above such alternative would not be 100% effective as killing the spids ( by any way) and loading the database is two diffrent task. Between both task execution, there must be some time gap may be in millsecond, and that time gap is suffcient for any login id to logged ins.

One more option can be :

We can make database in offline state( something like that so no one can use it) before load database, aftre that we will go for load database.

Kindly let me know your thoughts and suggest if any thing I am missing above.

I have posted the same in various forums as well, will update you if I’ll get any response.

till then..

bye

Categories: ASE Tags: , , , ,

Sybase Interview Ques Updated!!

February 21st, 2011 No comments

Guys,

Updated the Sybase ASE/Rep Interview Question Page which I came across recently.

Please have a look @  http://sybaseblog.com/interviewquestions/

Happy Learning !!

sybanva

Default,Rules and User Defined Datatype

February 6th, 2011 No comments

Question
=======
Consider a table creation script
create table table1(id int not null,
cost smallmoney default $10
)
will it allow null value in column “cost”?

Answer
======
No

Source (Unleashed)
Question
=======
How to find all tables and columns which are bind with a rule/default?
Answer
======
select “table”=o.name, “column”=c.name,”user”=user_name(uid),”rule”=object_name(domain)
from sysobjects o,syscolumns c
where o.id=c.id
and object_name(c.domain)=’rule/default name’

Sequence of events when using datatypes
=================================
sp_addtype ssn_type, ‘char(9)’, ‘not null’
go

create rule ssn_rule as
@ssn between ‘001111’ and ‘1111111’
or @ssn = ‘N/A’
go

create default ssn_default as
‘N/A’

sp_bindrule ssn_rule,ssn_type
sp_bindefault ssn_default,ssn_type

create table ssn_table
(ssn ssn_type, name varchar(30))
go
==================
A rule or default bound explicitly to a column override a rule or default bound to a datatype. A subsequent bind to the datatype replaces the bind to the column as long as the column and datatype have the same rule or default prior to modification.

Renaming Objects

February 6th, 2011 No comments

(Source – Unleashed)
Question
=======
If name of table is changed then stored procedure and views would work or will change to invalid state?

Answer
======
Even though the name of table has changed, objects like views and procedures that refer to that table by name are not affected by the change in the name. That is because SQL-based objects like Views and Procedures are stored both as text in the syscomments table and pre-parsed query tree identifying related objects by ID instead of Name. When a table name changes, a dependent view still works because the objectID of the table (stored in sysobjects) does not change.