To ArndW :
Sir, in fact , there is no more helpful massage reported. I mean I use a different Database userid. And I judge that probably becase the difference privilege between the two Database userid, but I don't know the specificful requirement of a Database userid to use sybase EE.
Search found 9 matches
- Sat Aug 01, 2009 6:23 am
- Forum: General
- Topic: sybase EE abort
- Replies: 3
- Views: 1481
sybase EE abort
hi, how are you every one? I develop a job which is extracting data from sybase database by sybase EE. I have two login users, and both of them can login in throgh sybase client. When I run the job, it finishes successfully using one user but abortes using another user. The messiage is "The par...
- Wed Jul 16, 2008 3:28 am
- Forum: General
- Topic: How to read time datatype from sequential stage
- Replies: 1
- Views: 1178
How to read time datatype from sequential stage
How are you, friends?
I have a ETL task to finish. The source is sequential file, in which a column is time type like:"10:59:40:543AM" or "8:59:40:543PM" .
So any friend can tell me a simple solution to finish it? Many thanks.
Best wishes to you!
I have a ETL task to finish. The source is sequential file, in which a column is time type like:"10:59:40:543AM" or "8:59:40:543PM" .
So any friend can tell me a simple solution to finish it? Many thanks.
Best wishes to you!
- Wed Jul 16, 2008 3:14 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to specify the timestamp format for the field like this?
- Replies: 5
- Views: 2190
- Tue Jun 03, 2008 1:01 am
- Forum: General
- Topic: Problem of Teradata task
- Replies: 4
- Views: 1602
I have designed a job, and using Teradata Enterprise stage as source. In this stage I defined a SQL (Select * from (Select 'aa' AS AA) t1)to post data flow, and a SQL (DELETE FROM CBS_AGDMX)to delete the table. It can work when I union the two SQL sentences. But my final aim is droping the table. As...
- Thu May 29, 2008 8:50 pm
- Forum: General
- Topic: Problem of Teradata task
- Replies: 4
- Views: 1602
Problem of Teradata task
Hello every one:
I have a task to finish. I want to drop a teradata table and want to use datastage to finish this task.
My server is in unix and the brand is 7.5.2. Please tell me which datastage I should select and tell me more detail.
Many thanks!
I have a task to finish. I want to drop a teradata table and want to use datastage to finish this task.
My server is in unix and the brand is 7.5.2. Please tell me which datastage I should select and tell me more detail.
Many thanks!
- Thu May 08, 2008 9:39 pm
- Forum: General
- Topic: problem of join stage
- Replies: 5
- Views: 2650
- Wed May 07, 2008 9:05 pm
- Forum: General
- Topic: problem of join stage
- Replies: 5
- Views: 2650
problem of join stage
We developed a complex job with several lookup stages.Now we should update the job in view of the attribute of lookup and join stage, and we decide to use join stage to repalce lookup stage. As I am going to finish my job and I use the join stage to replace the last lookup stage, a problem appears.T...
- Mon May 28, 2007 2:21 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to read longvarbinary column?
- Replies: 1
- Views: 1137
How to read longvarbinary column?
Hello,gentlemen!I encounter a problem about longvarbinary column. My source is Informix table, and there are sevral columns such as char or interger which can been exported successfully. But there is a longvarbinary column amoung them. The target is teradata.The job gettes aborted with error" U...