DSXchange

Hi Ray, Thanks for the reply. You'd better tell us what the error is, since the record delimiter in this file clearly is DOS-style. ... I mentioned the error in the first post which is: "Consumed more than 100000 bytes looking for record delimiter. " I am including the screenshot of the er...

Hi, We have multiple repeating (example would be a monthly report) excel files are sources. Instead of creating a DSN each time a new excel source, I created a vb script that would dump data into a csv file. I set the sequential file option/property 'Record Delimiter String' to 'DOS format'. But whe...

Want to clarify the behaviour of DS v8.5 HA given the scenario below: 1. Main Sequencer1 (MS1) have jobs JOB1, JOB2 and JOB3 and is programmed with the option restartability. MS1 was scheduled on DataStage1 (DS1), and DS1 broke down with MS1 aborting on JOB2. Am I right to say that when I run the sa...

ray.wurlod wrote:Not really. You need version 8.5. ...

I thought asorrell has implement HA on DataStage even before version 8.5.

asorrell, can we have your insight on this?

Hi,

can we implement ACTIVE-ACTIVE HA on Linux, particularly RHEL with DS version 8.1?

Administrator hangs when creating project. When we tried checking if the project was created, in the Projects directory (/opt/IBM/InformationServer/Server/Projects) a folder with the project name (IAC) was created, also files and directories under it were created. Dunno if the required files and dir...

1. Define your all parameter like servername, schema, uid, pwd etc at user defined enviroment variable. 2. Keep all these parameter in one parameter set like $DB_USER, $DB_SERVER etc. and save. It will be saved at Repository. 3. Open Parameter set\Parameter and double click on Default Value. 4. Sma...

hi, we used parameter set to pass values like db server name, schemas, etc. in our dev't server the name of the db server is bcudevt. but when our jobs were migrated to prod'n server, the db server name is bcuprod. so we expect just to change the value of the parameter set and run the jobs with no p...

ArndW wrote:If the IsNull() function does not return TRUE, then you don't have a null value in the column. Try a test job and set a date to a null value using SetNul() then test it again with IsNull() and you wil ...

But if I write it to a table or dataset and view it, it will display NULL

In a transformer stage, I need to trap null date values. I use IsNull(input_column). It recognizes that it is no null values, but actually there is. How can I go about this, thank you very much

im using designer to connect to datastage which previously i can do. all client applications like designer, director, and administrator cannot connect, but i can connect to web console. Welcome aboard. :D You are going to need to provide rather more information than that. For example, can you connec...

We cannot login to our server via the client Designer. It just hangs, no error messages. Please help...