DSXchange

ajongba

There is no error as such but i'll try to explain it in a better way. I have 2 jobs ,say "One" and "Two" are the job names, to be enhanced by us(some modification) and 2 new jobs say, "Three" and "Four" are the job names ,to be created. Now all the four jobs a...

ajongba

Only the two jobs sent for enhancement are enabled with multi instance option.No the sequencer job is not a multiple instance job(i did not enable as i don't know what to do with it :oops: ) similarly the other two jobs are also not multi instance enabled. The problem is while running the whole proc...

ajongba

Hi everyone, I have a problem in running a sequencer job as it use to change the job name into something like "jobname.invocationId" .I have 4 jobs made here, out of which two jobs were sent to us for inhancement, these jobs(inhancement) were sent to us with the allow multiple option enabl...

ajongba

If the job is being monitored, if the job is being edited, if the job is running; you do not want to unlock anything. The locks are there for a reason. ... How do we know that...the description in the director does not show anything like it is running or being monitoredor being edited.... please gu...

ajongba

In the Administrator. Make sure you 'Show All' in both panes and look very closely for relevant entries. ... I did show all in the upper and lower panes at first...I could see the locked jobs....On the upper pane i tried logging out the locked job but did not work...In the lower one inorder to acti...

ajongba

chulett wrote:

Code: Select all

SELECT JOBNO FROM DS_JOBS WHERE N ...[/quote]

I did get the internal number and tried clearing that too... but nthing happened...it is still locked.... and i m sorry being a standard member i could not see all the select statement...and where do we use the same... :oops:

ajongba

chulett wrote: How exactly did you "try freeing"? And what "didn't work" about it? ...

I went to the cleanup resource option and tried logging out the particular job but when i do that the status become unavailable but the job is not released.

ajongba

Hi I m back again I have a number of jobs that is run by a sequencer job which again is called by a unix script.As i was checking the jobs individually some of these jobs were found to be locked....I tried freeing it from Datastage Director but it did not worked.... Is there anyother way i can unloc...

ajongba

[quote="chulett ajongba - here's a solution for you. 1) Declare your field a Timestamp in the job of at least 19 characters. 2) Use this derivation: Oconv(Iconv(InLink.TheDate,"DYMD"),"D-YMD[4,2,2]") : " 00:00:00" 3) Let the stage generate the sql for you. If for s...

ajongba

I tried by changing the datatype to varchar and i got a warning as "ORA-01858: a non-numeric character was found where a numeric was expected"....What is going on????

ajongba

One which will is Oconv(Iconv(InLink.TheDate,"DYMD"),"D-DMY[2,A3,4]") ... I don't get it...... I used the code and it is still not inserting....I get a warning message saying "Attempt to convert String value "03-JAN-2005" to Date type unsuccessful"...What is ...

ajongba

Maybe your Oracle date picture is set up to require an alphabetic month. You can use TO_DATE function in Oracle INSERT statement to "translate" from other formats, or generate a date in the expected ... I tried inserting by using the sql command as "insert into tablename(columnname)v...

ajongba

i tried inserting the date 01/01/2005 by using the sql "insert into tablename(fmov)values (01/01/2005)" and it throws an error "not a valid month"

ajongba

Hi all I have a problem where i am unable to insert into oracle9i.The source is a fixed width file where the date is in this format 20050101(example date) and my target is suppose to be a date datatype. I tried using the Iconv and Oconv functions but i think i m missing out on something .The error m...

ajongba

Oh ...

Thanks for that info....

DSXchange

Search found 31 matches

Multiple Instance

Re: Job locked

Job locked

I don't understand!!