DSXchange

But doing that would remove the carriage return from the string. But business still wants to see the carriage return in database. So Tabel: Pakketten Sales per channel^M Excel: C+ migraties in input sheet IDTV"|"< needs to be stored in the database as Tabel: Pakketten Sales per channel Exc...

Hi all, I have a request in which we need to process a file deliverd by business (CSV). I've configured the sequential file stage to "Record delimiter string: DOS" , and the section Field Defaults: "Delimiter= |" The problem is that the column "process" can have a carri...

Hi, thanks from the feedback but I've taken a bit of a different approach. I've created an after routine with the following code: $INCLUDE DSINCLUDE JOBCONTROL.H ErrorCode = 0 JobName = Trim(Field(InputArg,";",1,1)) DirName = Trim(Field(InputArg,";",2,1)) Suffix = ".txt"...

Hi, I am trying to write a job, which dumps some information of the director to a file on unix when the job has aborted due to a fatal error. I've been looking with the search function and found some solutions using dsjob. Now I have the following statement dsjob -logsum -type FATAL -max 3 INTFUAT r...

In my case we were migrating DS 7.X to DS 8.X. DS 8 was running on a new machine and the ACL of the firewall did not allow me to make an ODBC connection to the database, something that did work on DS 7.X I also tried pinging the machine from the new Datastage8 server, which was no problem, so in the...

Ping doesn't tell you much. It could be that ping is allowed on the internal network but that the ACL on the routers are set in such a manner that connections on certain ports are not allowed, or that from one IP range to an other connections are refused. I had once a problem connection to a databas...

Currently the default value parameter is set $PROJDEF.
So is there a way to read the parameter value in the transformer ? I'm kinda curious now

Thanks now its working. But now you are actually reading the value of the project variable and you are not reading from the parameterset. But thanks anyway it works

hi, I've tried the function you suggested, now the job compiles but if i output the value of the function it remains blanco. Currently i've tried this: GetEnvironment("PS_DEF_VALUES.$DEF_UNKNOWN") GetEnvironment("PS_DEF_VALUES.DEF_UNKNOWN") The $DEF_UNKNOWN is a project variable ...

Hi all, I've got a weird situation. We've got a parallel job which has got as parameter a parameterset. The parameterset contains as parameters project variables. Now I can call without problem the #parameter.$projvar# in an oracle stage to specify the database connection. Now I want to use a proj v...

The problem was that the unix server on which the new datastage environment was installed, was in an other network segment. The ACL's of the routers did not allow connection from the unix machine (where DS was running) to the machine on which the database was running for an ODBC connection. The netw...

Problem has been solved. Apparently it was a firewall issue

I select the import tables for ODBC, select the DSN (db_messagent), then i enter the username and password, then datastage client hangs and after a while i get the following Datastage Repository interface (name of the window with yellow triangle) DSR.MetaGeta(GET.DSNINFO)(SQLConnect('db_messagent','...

If it's an informational message, can i try an sql statement after the DS_CONNECT to check if the connection really works ? (can't seem to find the command). In datastage designer we still have the issue that if we want to import table definitions for the ODBC database that we get the same error as ...

Hi all, We are migrating datastage 7.5 to 8 and I was changing the .odbc.ini and uvodbc.config file to be able to make a connection to a MSSQL database. When I try to test the connection from unix (with DS_CONNECT) or when i try to import the table data in datastage i get the following error: SQLCon...