DSXchange

HI Chulet, 12 characters i need to substring. I tried with following code also. "OCONV(ICONV(TRIM(INPUT_COLUMN[1,6]),"D4YMD[4,2,2]"), "D-YMD[4,2,2]") : " " : OCONV(ICONV(TRIM(INPUT_COLUMN[7,2]:":":INPUT_COLUMN[9,2]:":":INPUT_COLUMN[11,2]), "...

HI Guys,

Thanks for your reponse.

chulet,

My incoming year is 2 digits only.

Hi All, I am trying to populate string data in to timestamp. my source data format is YYMMDDHHMMSSSS , i need to populate this data in to target table having timestamp YY-MM-DD HH:MM:SS. To Achive this output i have been using this function "OCONV(ICONV(TRIM(INPUT_COLUMN[1,8]),"D4YMD[4,2,2...

Hi Chulet,


There is a procedure for problem.
we have to change the settings in "WEBCONSOLE FOR IBM INFORMATION SERVER".
Unfortunately i forgot the procedure for the same.
That's why i posted in dsxchange.

Please Don't consider my question as silly

Hi All,


I have installed datastage 8.0.0 in my system which is internet enabled .
It is successfully working when my system is internet enabled.
But i am not able to login into datastage when my system is disable from internet cable.

Plz give solution for this.

Hi chulet,


Sorry for Inconvienince.
My business rule is seconds> 60 i have to concatenate below 60.
That is any value like 58,59,57.........
Not only for 68.

Thanks & Regards,
Sankar.

Hi Chulet, I have timestamp column in target table.For that column few records coming from source are like this 09020517090667 09020517090668 0902-05-17 09 :06 :68 (YYYY-MM-DD HH:MM:SS) These records are populating as NULL values in my target table.Because seconds >60. Now my business rule is I want...

HI Chulett, My column format in target table is YYYYMMDDHHMISS. i need seperators like YYYY-MM-DD HH:MM:SS. For this already i have concatenated using oconv funtions in transformer stage. Now my problem is few records coming from source file for this column is containing seconds >60. My business rul...

Hi All, My job design is like this SEQFILE--------TFM--------MLOADstage. In this job i have a one column in file which is containing timestamp value in the format 09020517090634.(YYYY-MM-DD:HH:MM:SS) But few rows are coming with 09020517090668(YYYY-MM-DD:HH:MM:SS); Rows containing this value 0902051...

Hi All,

I am trying to load data from sequential file to table in teradata by using TERADATA-API stage.
job is finished with warnings for every column.The warning is follows.

"The source parcel length does not match data that was defined" .

Thanks for your response.

Hi chulet,

Sorry for consuming your time.
I have added this path "C:\IBM\InformationServer\Server\PXEngine\bin", in the system variable of 'path' .
In windows environmental variables.
Still the dsjob command is not recognising!
Does i need to change my path?

Hi chulet, I have included the path "C:\IBM\InformationServer\Server\PXEngine\bin" in the environmental variable of $PATH in the datastage administrator. and i am trying to call datastage job from this directory through windows command prompt, still the dsjob command is not recognising. Pl...

Thanks for your reponse.

Hi chulett,

Thanks for your reponse.
I am to trying call datastage job from windows command prompt by using command "dsjob -run " .
But 'dsjob' command is not recognising.
Does i need to do any set up for this.
Please suggest me.