DSXchange

Is offshore/Onsite kind of model then from your company somebody woule have been at onsite to co-ordinate ask him/her to call up the support.we have done upgradation here but have not checked up with the support we upgraded both datastage and database.My suggestion would be with both.

ds_dwh wrote:how to schedule job or sequence in unix

here any specific comand is used or shell scipt is used to execute the job

any one share the comand or unix shell script information

atleast syntax information fine


Thank's

Use cron in unix.

Have a shellscript in which call the sql for drop those constrints and indexes after the job finishes try rebuliding them using a shell script.Use before after subroutine if you use at job level,use rotuine activity if you use them at the sequencer level.

priyadharsini wrote:the source link key is columnA char(1) nullable = Yes and the reference link key is column A varchar(30) nullable = No

Try having the source and reference of identical in everything even with size ,datatype etc and try compiling and run it.

Hi, is there any tips to speed up an extract and loading process in datastage using Oracle database as source /target? Is the load method at oracle Enterprise stage equals to SQLLoader? And is append method in Oracle Enterprise stage equals to append DML in Oracle? for your information, my table is...

priyadharsini wrote:Lookup is having a single reference link and I tried running the job with 10 records only and Key column is of Varchar (1) datatype.

try increasing the size of the coulmn and run it

priyadharsini wrote:Lookup is having a single reference link and I tried running the job with 10 records only and Key column is of Varchar (1) datatype.

try increasing the size of the coulmn and run it

priyadharsini wrote:Lookup stage and Lookup key column is throwing this error.

How big is your lkp

chulett wrote:Ah... yes, things were "fixed" or tightened up to ensure proper operation as the product matured and kudos for catching that issue. And we know you meant "7.5" when you said "8.5".

Typos

So, more than just "a simple job just an oci stage", eh? Sorry, but I have no idea what you mean by "On the ref DB i have query from DB in which from the where clause i use the runtime argument from the source which will be to_char(:1,'MMDDYY')". :? If it means you are using tha...

Usually that comes from an unresolved parameter - #XXX# - or you've tacked on a trailing semi-colon. Both the hash and semi are "invalid characters" here. ... Basically i have the query in the i/p DB stage is Select to_char(sysdate,'MMDDYY') from dual On the ref DB i have query from DB in...

Sainath.Srinivasan wrote:I assume what you have supplied is only part of the sql.

Try running the SQL outside datastage and ensure it returns no errors or warnings. ...

I can view from the view data but i gives error on the job

I have a simple job just a oci stage where i have sysdate dual in which refered to a set of dates.the field am using has a fuction to_char for ex in the source i have to_char(sysdate,'MMDDYY') which again refered to the source databases.hte error am gettng is ORA-00911: invalid character any thoughts

We need some help. We have getting the error below on quite a few of our web services lately. The web services are "always on" with a minimum of 1 to a maximum of 5. The database it is connecting to is not down because we do a db upcheck before we process this job. It doesn't happen all t...

RK, I meant put Trace=1 and TraceFile=/tmp/odbctrace.out in your .odbc.ini under the [ODBC] section. Run your odbc job or odbc import from your non-working client; you then view the odbctrace.out file for details why Login fails. Anyways i found out the error was when my admin put in the file from ...