DSXchange

I've a feeling its becaue last column and its carriage return may be. Do you thik I can handle this problem using field properties of my SEQUENTIAL load file under the "Edit-Column-Metadata" field properties? May be I can handle throught Delimiter properties. I will try if its work I will ...

Found the function Thanks for the help
Regards
F

Hi All, I have a small csv file, It loading successfully into my target table. However, the last column which keeps only flag values "Yes" or "No" and some are nulls When I look into target Table (DB2) it show like: No□ Yes□ Those square boxes showing don't know why? I thought no...

Thanks to all of you. Its surprised .. didn't like "xcopy" so I try to use "copy" command and its works copy "G:\Training\Farhan\Infection_Control_SAmple_Extractxls.csv" "G:\Training\Farhan\Infection_Control\" Now I'm going to try to copy (Srouce) from outside...

(3) Use the "Execute_Command" in SEQUENCE job. No its not a routine.
I've only use "Execute_Command" in my sequence job
(4) Call my bat file like as follow under Command:

G:\Command\Run_Copy_Infection_Control.bat
Hope make sense

Sorry don't know what happed to my browser posted one reply several times.. After the last post I took following stesp (1) Reset the job by closing the datastage. (2) create a fresh job (3) Deploy " Execute_Command" (4) Assign the BAT file through browser on "Command" line G:\Com...

The following syntax I've written in my bat file. echo "Testing" REM REM xcopy /s "T:\Info_Team\Farhan\ETL\DW RFC\CC_xx_Infection_Control\*.csv" "X:\Training\Farhan\Infection_Control\" xcopy /-y "X:\Training\Farhan\Infection_Control_SAmple_Extractxls.csv" &quo...

Thanks for the reply... No the source file is not on the ETL Server? What I've done after your suggestion Create a new job simple Sequence-Job and browse the Run.bat file but its not working do I've to pass any parameters I've run my batch command on cmd window and its working fine but through Seque...

Hi All, Sorry I'm new on DataStage(InfoSphere). I only used basing stage control in jobs. What I want? I would like to (1) check the file on share dirve and once the file found (2)I like to pull through. I think the (2)nd step I can do but , could you please advise me for (1) What I've done so-far I...

Oops! My apologies , I just search on the forum and found Date Difference and replied. I will be careful next time.
Sorry to confuse you and thanks for your help its works

Kind regards
Farhan

PARALLEL JOB

Stage Variable svLOS: ICONV(IP_Spell_Epi_HRG_Src.ADMISSION_DTTM[1,10],'D4-YMD')
Variable 'ICONV' not defined

Thanks for your swift response. I think I will calculate the difference on Date only Not timestamp. So do I have to convert into Date first as currently the type in the db2 is TIMESTAMP and the difference values of (Admission DT) and (Discharge DT) will be in the field "Length_OF_Stay" fie...

Sorry I should have mentioned befoere my values is date+timestamp like : 2008-07-06 06:29:00.0 I think I need to conver into Date then time , in the following example I have used only one date , I assue if this work I can easily calculate difference by using minus - . I don't know how ICONV function...

I tried to use the following code but it does not like that.
the format of my fields(Admission_DTTM) is YYYY-MM-DD
Appreciate your help