Search results for query: *

Right, this seems to be working, tnx.

Consider the following: There is a table with 2 attributes, COPInstantieID as Int and LoketID as Int. Those 2 attributes are also the primary key. At some point an ExecuteSQL task runs this script: INSERT INTO Centraal.InstantieLoket( COPInstantieID, LoketID ) SELECT t1.COPInstantieID, 1 FROM...

Hi ESquared, I have an (imperfect) script to get all the sequences from a given set and I did some tests. I entered your example in the table, which stores the dependencies of each cluster. I then ran my script and received all sequences. I put these sequences in an Excelsheet and grouped all...

Sorry for the delay, did not receive any notifications on this thread. "Is this close to what you mean?" Yes it is exactly right. A Flexgrid is comparable with cells in an Excelsheet. On your other remarks, you might be right, I'll have to think on this and discuss it with the designer. Tnx for...

This set will be shown in a screen, in a Hierarchical Flexgrid to be exact. The cells in this Flexgrid will be stretched or merged where appropriate. If I take example 2: Cl_01=> Cl_02=>Cl_08 Cl_07=>Cl_08 Stretched: Cl_07 will be stretched to the width of Cl_01 and Cl_02. Merged: Cl_08 in...

OK, here's a test example: PrevJobname Jobname Cluster_01 Cluster_02 Cluster_02 Cluster_04 Cluster_02 Cluster_08 Cluster_03 Cluster_04 Cluster_04 Cluster_05 Cluster_05 Cluster_06 Cluster_07 Cluster_08 There are 2 sequences here: Cl_01=>Cl_02 AND Cl_03=>Cl_04=>Cl_05=>Cl_06 And Cl_01=>Cl_02...

Imagine this situation: Job3 needs to start AFTER Job2 has finished AND Job4 has finished. Job2 can start AFTER Job7 has finished. Job7 and Job4 have no preceding job and can run independently from each other. It's difficult to explain here without graphic options, but I'll try. The sequence...

ESquared, and all of you, yes you've helped, up to a point. I still am looking for a solution where 2 jobs(independend from each other) need to finish for a third job to start. I'm working on 2 solutions, 1 of them with a different table, where some sequence information is stored as well. I...

Jobs maybe used in different sequences. Sequences may change over time, added and deleted. Re-usability is the idea behind this.

Yes, there are 2 job-sequences there; I need to get both those sequences. But I'm on the right track, I think. I was hoping there would be an easy, simple way of doing this, but I guess not. Thnx, FreeHansje

Hi LNBruno, In the table you described the column Jobname holds the Job, which can only start after the job in column PrevJobname has ended. In your example 2 sequences would have to crop up: 1 Job1 => Job10 => Job20 2 Job2 => Job30 => Job40 => Job50 Now, these are single-item sequences...

Sorry, you are right, I should have given an example. Suppose you have this sequence: Job10=>Job30=>Job20 AND JOB25=>Job15 Translation: first Job10 needs to finish, then Job30, after that Job20 AND Job25 need to finish before lastly JOB15 can start. I hope I make myself clear.

I have this table CREATE TABLE table1( Proc VARCHAR(10), PrevProc VARCHAR(10)) Both fields are mandatory. In this table sequences are stored of jobs to run. PrevProc will hold the name of the job which has to finish before the job in Proc can run. What I need is a resultset per sequence, which...

Hi Phil, Tnx for answering. I did re-create the publishing from scratch, after recreating the targetDB scripted from the publishing db. Same problem. And I use Redgate... Still looking, but I really am flabbergasted

Hi, We're running a replicationprocess for months now, and 2 days ago it broke down, for no appearant reason I can detect. The setup is this: A SQL2K server has a publication defined on a database, consisting of several dozen tables. It is a transactional publication, running continuously. There...

Hi there, I am new to PowerDesigner and I am playing with it to find out, if my department can benefit from it. What I really want to know, and cannot find on the Sybasesite is this: If I have a MODEL.CDM and a therefrom generated MODEL.PDM, can I automatically apply changes made in the CDM to...