DSXchange

kcbland wrote:Search the forum over the manual. We've been discussing job control for years, there's lots of samples.

Thanx Ill do it
Jim

Jim, if you wrap your server job inside a sequence job you should find the setting of job parameters easier. In the job stage you can write some BASIC code to set the timestamp in the Parameters Value Expression field of the job stage. You've got more flexibility setting a parameter here than you h...

The string command seems to handle the command timedate() as a string. its not returning the actual date. how do I handle that? Jim How are you using the job parameter and where? Derive its value and set the parameter at runtime. Since it's STRING, you can put anything into it. If you're attempting...

JDionne wrote:

kcbland wrote:Just create a job parameter (what you're calling a prompt) with a datatype of STRING.

I knew there had to be an easy way to do that. Thanx
Jim

The string command seems to handle the command timedate() as a string.
its not returning the actual date.
how do I handle that?
Jim

kcbland wrote:Just create a job parameter (what you're calling a prompt) with a datatype of STRING.

I knew there had to be an easy way to do that. Thanx
Jim

I know that I can set up a transform stage variable and I know that the job has prompts, but I need a global Variable that I can use in multiple transfrom stages. It dosent need to be a prompt, and prompts dont apear to be able to handle what I need I need a date/time stamp, and prompts seem to only...

It depends on the target database. Do it the same way that you would for the target database. For example, if the table contains columns AN1, C1, C2 and C3 (where AN1 is the autonumber column), you would either: INSERT INTO table(C1,C2,C3) VALUES (?,?,?); or INSERT INTO table(AN1,C1,C2,C3) VALUES (...

It depends on the target database. Do it the same way that you would for the target database. For example, if the table contains columns AN1, C1, C2 and C3 (where AN1 is the autonumber column), you would either: INSERT INTO table(C1,C2,C3) VALUES (?,?,?); or INSERT INTO table(AN1,C1,C2,C3) VALUES (...

It may be even simpler than that. :) If you already had Designer open, its view of what's in the Repository was as at the last time it was accessed, opened or refreshed. It may be sufficient just to choose Refresh from the View menu in Designer (or its shortcut key, Ctrl-R). I actualy had shut down...

I have a column in a table that is autonumber. I dont want to input anything there so I set up the dirivation to @Null. The database doesnt like that at all. How do you handle an autonumber column in the transform?
Jim

Jim Have you imported metadata from any DSN yet? If not then in Designer right click on Table Definitions and import a table from a DSN. Afterwards that DSN will show up in the drop down list for Data Source Names in an ODBC stage. Kim. All of my tables have been imported through manager...do I hae...

Jim Have you imported metadata from any DSN yet? If not then in Designer right click on Table Definitions and import a table from a DSN. Afterwards that DSN will show up in the drop down list for Data Source Names in an ODBC stage. Kim. All of my tables have been imported through manager...do I hae...

I can not see my odbc connection in designer but I can see them in Manager. I got a previous reply as follows Jim You should open a new topic on this but ODBC shows up when you import metadata. Only the DSNs which you have imported metadata show up. You should see all the DSNs when try to import. Ki...

How about odbc connections...I cant see any of my connections in designer but i can see them all in manager??????

I doubt you are getting "phantom error 768", more likey an error in phantom 768... which is why it is changing. Have you looked into the '&PH&' directory in your project? (I'm assuming it's named the same on Windows as it is on Unix) There should be phantom entries in there corrre...