DSXchange

I am using the ExtractLogMsgs subroutine to collect the job logs in a text file. The subroutine works fine for existing files with the JobName.log in the below call. Call DSLogInfo("Open Output Log Filename ", "ExtractLogMsgs") OutputLogFname = LogFileDirectory:"\dsEtl_"...

You are right. Is there a ptach available that you know to fix this issue?

I have Environment Variables created in a project. When reference in a job I have the default value set to $PROJDEF under job parameters. The "View Data" in the stage is throwing "TNS ERROR". But when I take off $PROJDEF as default value and reload the environment variable it tag...

When I am trying to execute oracle package to refresh Materialized view from "Before SQL" in Oracle OCI. exec dbms_mview.REFRESH( 'ABC'); It is throwing the folowing Oracle error "ORA-00900: invalid SQL statement". It works fine when I call the same in a batch script. Just wonder...

Thanks, Ray.

I appreciate your quick response. That helped!

Hey Guys, I am sure that there might be tons of threads on this topic. Specifically, I am looking for queries that pull the referenced uv objects in a project from Command in Administrator. Example: Query to get the objects (Links, Jobs) that a Hashed File is referenced to. Any help is appreciated! ...

SELECT A.COL1, B.COL1, A.COL2, B.COL2, C.COL1 from TAB1 A, TAB2 B, TAB3 C WHERE A.KEY = B.KEY(+) AND B.KEY=C.KEY or can use a sub-query in the user defined sql in DRS stage, if you are using DS7 and higher. The A.COL1, B.COL1, A.COL2, B.COL2, C.COL1 will be the columns in the DRS/Oracle/ODBC stage.....

I think you need to use the ODBC stage to call stored procedures. The out parameters of the stored procedure would be the input columns in the stage and map them to the target stage...

Try to execute the shell on the server by logging into the box. If it is returning the the "No command output", it means the code in the shell script is not returning any output..

In the logs of the server jobs under the "Starting Job" and "Environment variable settings:" messages the Source and Target Passwords are not encrypted though we had set them to as encrypted at the Project level. How can I make the PWD's encrypted in the job logs? Any help is app...

try viewing data from Source Stage using "VIEW DATA". That would help to troubleshoot if the error is because of the incorrect login, SID(database name) or the SQL itself.

Try increasing the performance parameters. Increase the buffersize to some reasonable number. It defaults 128kb. Also, check the stage commitpoint parameter. If this doesn't help use the bulk stage. Tweak the indexes on the source database. Just restrict your query by "WHERE ROW NUM < 1000"...

Try wrapping the TrimB(TrimF(LINK.COLUMNNAME))="SUN"..

I have the following DS job design. DRS stage type is used for reading and writing data between the Source and the Target Source--------->Transformer-------------Target Parameter BUSINESS_DATE (DATE) is passed as date to the job and is being used in the transformer to map to a target column EFFECTIV...

Use the Cats function.

Here is the Syntax of concatenatiing 5 fields(Columns)

Cats(Cats(Cats(Cats(ColA,ColB),ColC),ColD),ColE)