DSXchange

Hi, I have column in my oracle with data type Timestamp (6) with local timezone .I am not able to view the data from this sort of columns. In Datastage server we have mapped with this column as Timestamp 38 and were able to read the data. please advice me on handling this in Datastage parallel.

kduke wrote: If you want to know how to use it then let us know.

Yes i want to know how to use it

I have checked the spelling but i still get the same error

I have used a code snippet like this: Equate TransformName To "rtnXmlChange" VarCount = DCount(InitialValue,',') For i=1 To 2 GoTo Read Next i Read: OpenSeq SourceFile To SrcFileVar On Error Call DSLogFatal('Error ' , TransformName ) Locked Call DSLogFatal('Locked ' , TransformName ) Else ...

Hi all, I have written a routine that gets the position of a certain character in astring and use the position to get value from another string.. the code is used is Equate c_routineName To "rtnSplitRowsToColumns" Ans='' Lvl_indx=0 find_flag='' if Lvl_name<>'' and Lvl_order<>'' and Lvl<>''...

I have tested the same. I am able to get the values but there is an attached extraspace to the value when i see the director aftter the value DSLogs

ChRtn..AfterJob (sample): Failed to open directory /data/sample/DSLogs


how can i remove the empty string

I have gone through this the variable is echoed only when value is set in my .profile.h file
else it is not echoing the value.
I can't echo the value from the DSParams file.
EVEN in the DSParams file the value is not set

No. 1. You are opening up a local hashed file called "JobRunInfoParms". 2. You then try to open a sequential file, Can any other file be opened from the loca as open a hashed file? The only thing i want to do I am able to open a hashed file from local ? similarly can i open any ther file ...

Is code to open the sequential file and read it from the project default directry correct?

I have seen that when the job has warnings the routine returns wwit error number 3 tha i have specified.

I this the correct coding?

when i run this code in the routine i get the following error message Compiling: Source = 'DSU_BP/DSU.ReadParamsFile', Object = 'DSU_BP.O/DSU.ReadParamsFile' ? 0005 ON ERROR Call DSLogWarn('Failed to open file DSParams. Error':STATUS(), c_routineName ); Return ^ WARNING: no RETURN value specified, n...

Hi all, I am reading a file which is in Project default location and try to concate tha values. Please see the code that i have used. correct where ever it is wrong OPEN "","JobRunInfoParms" TO v_connectionParamsDataFile ON ERROR Call DSLogWarn('Failed to open file JobRunInfoParm...

Hi all,
while creating server jobs if we don't specify any path where will these sequential files be residing.

Is it the same location where the DSParams file is located?

thanks. I got it

I'm not quite sure what your question is. The code snippets don't look incorrect (if you assign the appropriate parameter name to the v_paramName variable) ... based on the paramtype that i get i want to change the values the output that i get out of this line is v_paramtype = DSGetParamInfo(v_jobH...